vlookup formulas returning no values

[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?

[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.

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

[wmjenner]

Are you sure you don't mean HLOOKUP?

[Dave Peterson]

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

[wmjenner]

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.

[Dave Peterson]

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