With the lookup values in A1. B1, C1 you would need to use HLOOKUP
=HLOOKUP(A5,A1:E2,2,FALSE)
With the values in A1, A2, A3 etc this works,

"MrSales" wrote in
message ...

I'm trying to use VLOOKUP to find the corresponding cells to a
particular dash number.

Example
A1 B1 C1 D1 E1
-3 2 4 X 3
I want to be able to enter -3 in a a cell containing VLOOKUP to get
what is in cell C1. It says I have an error in the formula. I have
various dash numbers that i'm working with. Is it the (-) that's
causing a problem?

Thank You,


--
MrSales
------------------------------------------------------------------------
MrSales's Profile:
http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=564333