Quote:
Originally Posted by Jenniferpod
I have two worksheets. In cell a2 of worksheet 1 I want to find if the value of worksheet 1 cell b2 exists within worksheet 2 column b. If found, I want to return the value of worksheet 2 column a (same row that the the original lookup was found). If not found, I want to leave the cell blank.
|
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},SHEET2!B:B,SHEET2 !A:A),2,FALSE),"")
This should do what you need if you're using Excel 2007 or later.