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.

Mogle wrote:

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?

--

Dave Peterson