returns the name of the guide, based on a name in cell

[marreco]

Hi.

I'd like to return the name of the guide, based on a name in cell

see attachment.

[DGagnon]

try this, it might give you extra comma's but shoudl work

=IF(ISNUMBER(MATCH(A2,Plan1!A:A,0)),"Sheet1","")&IF(ISNUMBER(MATCH(A2,Plan2!A:A,0)),",Sheet2","")&IF(ISNUMBER(MATCH(A2,Plan3!A:A,0)),",Sheet3","")&IF(ISNUMBER(MATCH(A2,Plan4!A:A,0)),",Sheet4","")&IF(ISNUMBER(MATCH(A2,Plan5!A:A,0)),",Sheet5","")

[marreco]

Thank's solved, perfect!!

[e4excel]

Hi Marreco,

DGagnon's solution definitely works and is the most pertinent one, however I was thinking if you had more no of Sheets then you will have to write those many nested IF condition to capture for every Sheet considered..

I am trying to get this for Multiple SHeets. but in vain..

Warm REgards
e4excel