Thank you for finding that! I pulled the information in my worksheet off an
AS400 Query, and it inserted a space in the front of each cell thas I was
searching on. I did a quick find and replace, and it works great! Thanks for
catching it!!

Kathy

"Gary Brown" wrote:


=VLOOKUP(I2,[PLLIST.xls]Sheet1!$A$2:$C$500,3,FALSE) is fine, I have
tested with this excat formula and it worked fine. I can only assume
that the value in I2 does not exactly match the values in column A of
Sheet1 in the workbook PLLIST, are you sure you don't have a space
after the value in either I2 or in column A?


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=520620