Mr.Shorty,
It makes sense, however when I make the changes, I get a #REF!. Sheet
1, Col A contains a constant text and Sheet1 Col B contains the Code. I
am using Vlookup to search Sheet2 ColA for the constant from Sheet1 Col
A and extracting the correlating data from Sheet2 ColB into Sheet1
ColB.
Here is the formula I'm currently using:
=VLOOKUP(A1,Sheet2!A1:A100,2,FALSE)
As a side note, when I change the col Index from 2 to 1 I get the value
of Sheet2 Col A in Sheet1 Col B.
Hope you can help me out with this,
Jeff
--
JPriest
------------------------------------------------------------------------
JPriest's Profile:
http://www.excelforum.com/member.php...o&userid=24695
View this thread:
http://www.excelforum.com/showthread...hreadid=382636