Lookup functions always return n/a ???

[FluidPowerOne]

I have a large work book that that contains approx 2200 rows o
information. Each row contains about 100 columns of information an
each of these pieces of information come from look-up functions from
different sheet. My objective with this workbook was to create it in
way that I could use it as a template to create other sheets o
information with similar properties. The purpose of this project was t
take knowledge that wasn't available to other employees in my compan
and make it available to them without the time it takes to research th
meanings of the different codes in the workbook.

That all being said, sorry I tend to be long winded, I prefer to us
index/match formulas as opposed to other look-up functions because it i
so versatile. My problem comes in that I keep getting a n/a return on
specific formula located on a sheet in the book labeled 'Look-up Sheet'
This formula is supposed to take the user's input and look back at
sheet called 'H-DATA' and return the corresponding information.... i
doesn't work and I can't figure out why. I have tried lookup, vlookup
& index/match. I have tried slapping my computer and calling i
ridiculous name even with no result other than n/a.

I am currently using Excel 2003, because my company refuses to update.
Have I reached the limits of this Excel version? I would be happy t
post this workbook but I'm unsure of how to do that. The attach file
tab doesn't have the .xls extension available... not sure if it wil
allow me to post my work so other can see it. I would be happy to emai
it to anyone that is willing to help....

Please help... I'm so close to finishing this thing

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Mazzaropi]

I have a large work book that that contains approx 2200 rows o
information. Each row contains about 100 columns of information an
each of these pieces of information come from look-up functions from
different sheet. My objective with this workbook was to create it in
way that I could use it as a template to create other sheets o
information with similar properties. The purpose of this project was t
take knowledge that wasn't available to other employees in my compan
and make it available to them without the time it takes to research th
meanings of the different codes in the workbook.

That all being said, sorry I tend to be long winded, I prefer to us
index/match formulas as opposed to other look-up functions because it i
so versatile. My problem comes in that I keep getting a n/a return on
specific formula located on a sheet in the book labeled 'Look-up Sheet'
This formula is supposed to take the user's input and look back at
sheet called 'H-DATA' and return the corresponding information.... i
doesn't work and I can't figure out why. I have tried lookup, vlookup
& index/match. I have tried slapping my computer and calling i
ridiculous name even with no result other than n/a.

I am currently using Excel 2003, because my company refuses to update.
Have I reached the limits of this Excel version? I would be happy t
post this workbook but I'm unsure of how to do that. The attach file
tab doesn't have the .xls extension available... not sure if it wil
allow me to post my work so other can see it. I would be happy to emai
it to anyone that is willing to help....

Please help... I'm so close to finishing this thing.

Help from *Brazil*
Good afternoon *FluidPowerOne*.

*A)* -"...I am currently using Excel 2003, because my company refuses t
update. Have I reached the limits of this Excel version?..."-
*_Answer:_* No. The limit for Excel 2003 is: 65,536 rows; 256 columns
Total of 16,777,216 cells

*B)* -"...The attach files tab doesn't have the .xls extensio
available... not sure if it will allow me to post my work so other ca
see it..."-
*_Answer:_* You must *ZIP* your file before attach it to the forum

Attach your file here and explain exactly what you want.
Put a clear example about the desirable result.

Remember, you are a master of your data but we don´t know nothing abou
them. Then be so clear as possible on your explanation.

I believe that you will receive help sooner.
Have a nice Day

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Mazzaropi]

I suppose that I should add that I since I had to chop down the workboo
to fit for uploading you won't find the 'H-MC' sheet that I spoke o
previously nor any of the information "to the right" of the assembl
number and model codes in sheet 'H-DATA'.

None the less, the problem persists even without the additional data.

Help from *Brazil*
Good Morning *FluidPowerOne*.

A)[/B] -\"...LOOKING AT SHEET 'LOOK-UP SHEET' YOU'LL FIND TH
AGGRAVATING \"#N/A\" THAT I AM SPEAKING OF...\"-
*_ANSWER_*: THE MAIN QUESTION IS: YOU´RE COMPARING A *NUMBER* FORMAT
'LOOK-UP SHEET' F2 * TO A *TEXT* FORMAT * 'H-DATA' COLUMN

Try to use this one at: 'Look-up Sheet' D4*
*Before*: =INDEX('H-DATA'!C2: D300,MATCH('Look-up Sheet'!F2,'H-DATA'!D2
D300,0),1)
*Now...*: =INDEX('H-DATA'!C2: D300,MATCH(*TEXT(*'Look-u
Sheet'!F2*,0)*,'H-DATA'!D2: D300,0),1)

Tell me if it worked for you.

Have a nice Day

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[FluidPowerOne]

Try to use this one at: *'Look-up Sheet' D4*
*Before*: =INDEX('H-DATA'!C2: D300,MATCH('Look-up Sheet'!F2,'H-DATA'!D2
D300,0),1)
*Now...*: =INDEX('H-DATA'!C2: D300,MATCH(*TEXT(*'Look-u
Sheet'!F2*,0)*,'H-DATA'!D2: D300,0),1)

Tell me if it worked for you.

Have a nice Day.

Worked perfectly. I had a similar problem with another formula in thi
workbook that was solved by using the properties of the cells menu t
change the format from number to text. I tried that in this scenario a
well and kept getting the #N/A error.

Why would that not work in this instance and require the formula t
format the data

+-------------------------------------------------------------------
+-------------------------------------------------------------------