Is it possible to set up a VLOOKUP that works something like this?
Enter value in sheet1!A1
check this value in sheet2!A:B
If value is found in A return value in B to sheet1!A2
If value is found in B return value in A to sheet1!A2
--
blain
------------------------------------------------------------------------
blain's Profile:
http://www.excelforum.com/member.php...o&userid=34368
View this thread:
http://www.excelforum.com/showthread...hreadid=552916