Find function

[Jenniferpod]

I have two worksheets. In cell a2 of worksheet 1 I want to find if th
value of worksheet 1 cell b2 exists within worksheet 2 column b. I
found, I want to return the value of worksheet 2 column a (same row tha
the the original lookup was found). If not found, I want to leave th
cell blank

 

[Spencer101]

I have two worksheets. In cell a2 of worksheet 1 I want to find if th
value of worksheet 1 cell b2 exists within worksheet 2 column b. I
found, I want to return the value of worksheet 2 column a (same row tha
the the original lookup was found). If not found, I want to leave th
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

 

[Jenniferpod]

=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.

It keeps saying I have a circular referenc

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Jenniferpod]

Have a look at the attachment. Does this clear things up?

It would be a case of just a straightforward VLOOKUP if your C and
columns were the other way round, but as they're not I've used CHOOSE t
do a "left lookup".

Let me know if you need any of it clarified.

Excellent! Thank you

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

Excellent! Thank you.

Not a problem. Glad I could help. :

+-------------------------------------------------------------------
+-------------------------------------------------------------------