Look up question

[RickeyS]

Hi,
Using 2003

I have a name in cell A2 sheet 1,
I want to find/match that name on one of four different sheets (in same workbook, sheet 2 thru sheet 5)
Then in cell C2 paste the sheet name that it was found on.

Is this possible and if so how?

Thanks
Rick

 

[Aladin Akyurek]

Hi,
Using 2003

I have a name in cell A2 sheet 1,
I want to find/match that name on one of four different sheets (in same workbook, sheet 2 thru sheet 5)
Then in cell C2 paste the sheet name that it was found on.

Is this possible and if so how?

Thanks
Rick

Try...

C2:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2,3,4},
     MATCH(A2,Sheet2!A:A,0),MATCH(A2,Sheet3!A:A,0),
     MATCH(A2,Sheet4!A:A,0),MATCH(A2,Sheet5!A:A,0)),
     {"Sheet2","Sheet3","Sheet4","Sheet5"})

 

[RickeyS]

Works Great!

Thanks so much,

Rick

 

[Aladin Akyurek]

Works Great!

Thanks so much,

Rick

You are welcome. Thanks for providing feedback.