Multiple XLOOKUP/INDEX(MATCH) functions to return one value.

Hello all,

Apologies I am very new in the Excel world, so some context and example for my question.
I am just wondering if there is any way to do so.

E.g
I want to do a search and match on Sheet 1 for a specific cell with text lets say cell A2 , to check if it matches any cell in a column in
Sheet 2, then Sheet 3, Sheet 4, if it matches, it will return the value of another column in that row that it matched. If it matches multiple sheets it will return the value of just one, preferably just the one condition stated, example sheet 2.

I am able to do a INDEX(MATCH) and XLOOKUP to search just sheet 1 against sheet2 and return the value of another column, however I am unable to search multiple sheets. Is there any way to do so?

Sorry if I am unclear with my query, if more clarification is required please do let me know.
And thanks in advance for any help you guys can provide.

It's always best to attach a sample workbook for us to work with. See the Yellow banner at the top of this page.
You can use XLOOKUP, and there's an argument for if "not found". You can embed another xlookup for the next sheet, etc. You might also be able to pull all the sheet together in an array and do the search that way as well.

Terribly sorry, I have attached a sample that I was working on.
Under Sheet 4 tab, Column F's coding is what I was able to find.
However I have no idea how to add more Worksheets into the search term as using if(or) just keeps prompting an error.

One option - in Sheet 4, Cell F2 and copied down:

=XLOOKUP($B2,Sheet1!$B$2:$B$7,Sheet1!$E$2:$E$7,XLOOKUP($B2,Sheet2!$B$2:$B$7,Sheet2!$E$2:$E$7,XLOOKUP($B2,Sheet3!$B$2:$B$7,Sheet3!$E$2:$E$7,"Not found",0),0),0)

Thank you very much, the code seemed to be working perfectly.
Really really appreciate the help Gregb11!

Roger, Thanks I've added rep to Gregb11 just now, adding to yours as well. Thanks again for the help, this Excel community seems amazing.

Thanks for the feedback and the rep!