vlookup formulas returning no values
 

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?

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

Are you sure you don't mean HLOOKUP?


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394267

I'm positive I didn't.

wmjenner wrote:

Are you sure you don't mean HLOOKUP?

--
wmjenner

------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394267

--

Dave Peterson

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


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394267

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

Sorry about that!

wmjenner wrote:

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

--
wmjenner

------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394267

--

Dave Peterson