I am trying to set a specific set of cells in a form and when done with the
first set of cells to go to the next set of cells which are futher down the
sheet by clicking return

I am using =VLOOKUP($A$32,Data!$A$4:$M$18,MATCH($B$3,Data!$B$4:$M$4,0)+1,0) in order to search for two dimensions in a table.  I am a very green user so do not know much in the way of Excel.
The problem is when there is no matching field I receive a #NA.  How do I just get a blank ...

I need to subtract the difference between two different times.  For example:
1) In Cell A1 I have typed 03:24.65
2) In Cell B1, I have typed 05:12:55
I formatted the cells as: mm:ss.00.

I have hundreds of entries that are formated as text cells.  the values in
these text cells are sizes such as 2 1/4 i have broken this up to two cells
one with a 2 and one with 1/4 but they are still formated as text cells.  i
want to make the fraction formated as a fraction but it ...

Okay I am doing something wrong here.
I have a little over 350 lines of information that look something like this:
001 - ROTOR WILL NOT TURN
I need to split the 001 from ROTOR WILL NOT TURN and get rid of the hyphen

I have multiple worksheets each representing a year. In a summary
sheet I want to return values from each year's worksheet. I'm using
=INDIRECT("'"&A$1&"'!$B5")
in which A$1 returns the year at the top of the summary worksheet

The following formual looks up the result of two variables B3&E3 and returns
the spend number in £'s attributed to the site and vendor looked up. This is
being used for three yyears worth of data.
Trouble is, when there is no spend on a vendor in one year it returns #NA

I want to valided or check of a cell value which content alphanumeric. the
features of alphanumeric value is  -
1) lenth should not exceed 10
2) First five character should be alphabatic, next four character should be

When I refresh my pivot table, either manually or via code, all the fileds
vanish. Not the values but the table itself goes back to where I have to
place the fields in the table again.
Is there something I need to do to keep the formatting for the table?

I have searched this group and not found an answer.
I need
1) a count of the number of rows having a 3 in ANY of the three columns
2) where column D contains R

I have a sheet that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another sheet I have the
a similar format with the same columns. I need to check I need to move
the values of the order to the second sheet but I must check against

I have data that is all being put into one cell and I am trying to find a way
to "extract" pieces of the info into separate cells, much like the "text to
columns" function, but I need "text to rows"
the data is organized like this:

Is it possible to have tabs inside other tabs? I want to have 12 tabs for the
months and then 4 tabs inside of those 12. I would also like to take the
total from the tabs inside and put them on the monthly tab. This is for
simple sales tracking for 4 people. Can anyone help me? I ...

I've written some functions at work and saved the workbook as an add-in.
Another workbook that used this add-in worked fine at work but not when
I brought it home (presumably as the add-in was not on my home machine)
So I copied the text of the functions, put them in a new workbook ...