Forum Discussion

Copper Contributor

Dec 11, 2025

Formula to retrieve data from several sheets and return values from given criteria.

I am trying to get data from each of our areas of the school staff timetables EY MY LY and summaries what days each staff member works where to another sheet, as staff move around. I would apprec...

excel

office 365

swexcelnurd

Copper Contributor

Feb 03, 2026

Ive finally got back to this one.

Thanks so much everyone, I tried the formula you sent iliru and lobo360, really appreciate this. Both returned #NAME? as per screenshot.

This is exactly what I am trying to retrieve from all the other sheets. I would like the summary to show what location each staff member is on each day.

=If(IsError(VLOOKUP($A10,EY!C$3:C$33,1,FALSE)),If(IsError(VLOOKUP($A10,MY!C$3:C$33,1,FALSE)),If(IsError(VLOOKUP($A10,LY!C$3:C$33,1,FALSE)),”Not Found”,”LY”),”MY”),”EY”)

OliverScheurich

Gold Contributor

Feb 03, 2026

=IF(ISERROR(VLOOKUP($A10,EY!C$3:C$33,1,FALSE)),
IF(ISERROR(VLOOKUP($A10,MY!C$3:C$33,1,FALSE)),
IF(ISERROR(VLOOKUP($A10,LY!C$3:C$33,1,FALSE)),"Not Found","LY"),"MY"),"EY")

It doesn't return the NAME error if i use " instead of ” in my sample sheet. However i'm not sure what you exactly want to do.