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