Unsolved

This post is more than 5 years old

81 Posts

3562

June 24th, 2005 23:00

VLOOKUP does not return a value

I am using Excel 2003, and doing some engineering work.  I have set up a table where the lookup value, on the far left of the table, is a value expressed in inches.  The values are 1.5", 2", 3", 4", 6" and 8".  VLOOKUP will retrun correct values for all of lookup values other than for 1.5".  At any cell where the lookup value is 1.5", I get "#N/A".
 
Any idea as to what is causing this to ahppen and what I can do to correct it?
 
 

1.7K Posts

June 25th, 2005 00:00

Could you please post the VLOOKUP formula? I can then tell if it is looking for an exact value.

0 events found

No Events found!

Top