vlookup formulas returning no values

M

Mogle

just upgraded to excel 2003.....yesterday my formulas worked, today they
dont. here is the formula I am using :

=IF(ISNA(VLOOKUP(A6,'OTC AUTEX'!$D$1:$H$179,3,FALSE)),"",VLOOKUP(A6,'OTC
AUTEX'!$D$1:$H$179,3,FALSE))

It should return values to the current sheet from the OTC AUTEX sheet, but I
am getting nothing. I tried F9 to refresh, and got nothing. Any thoughts?
 
D

Dave Peterson

If you just use:
=VLOOKUP(A6,'OTC AUTEX'!$D$1:$H$179,3,FALSE)
you'd get an #n/a! error.

I bet if you look at the value in A6, it doesn't match the value (in the cell
you think it should in "OTC Autex" column D.

Extra spaces (leading/trailing/embedded) and text numbers vs number numbers are
common problems.
 
W

wmjenner

I didn't mean you, Dave, I meant Mogle. I KNOW you have this stuf
down. I tried the formula as he gave it and got #N/A! because I had i
backwards (vlookup instead of hlookup). As soon as I switched it, I go
the values as expected
 
D

Dave Peterson

Yeah, I figured as much. But sometimes I post for my own amusement.

Sorry about that!
 
Top