Thread: VLOOKUP Query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blain
 
Posts: n/a
Default VLOOKUP Query


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