# Formula to search multiple sheets and return specific cells from the matched row

1. ## Formula to search multiple sheets and return specific cells from the matched row

Good Morning,

I can usually figure out my formulas between reading, experimenting and web examples but Im stuck on this one.

I want to use data in column B of Master, to search all other worksheets for a match.
If a match is found, I want to return the data in cells Bx, Dx, Ex, from the matched row. where x = the row number of the match.
If not matched on any sheet, populate with "no match found"

I have shown the result I'm trying to reach on Master in highlighted red.

Thanks alot for the help !!

2. ## Re: Formula to search multiple sheets and return specific cells from the matched row

If you have a small number of sheets, you can use nested IFERROR functions like so

=IFERROR(INDEX(MYSHEET1!B\$1:B\$5,MATCH( \$B1, MYSHEET1!\$A\$1:\$A\$5,0)), IFERROR(INDEX(MYSHEET2!B\$1:B\$5,MATCH( \$B1, MYSHEET2!\$A\$1:\$A\$5,0)), IFERROR(INDEX(MYSHEET3!B\$1:B\$5,MATCH( \$B1, MYSHEET3!\$A\$1:\$A\$5,0)),"No Match Found")))

If you have a significant number of sheets, you'll need to go to VBA. I can't help you there.

3. ## Re: Formula to search multiple sheets and return specific cells from the matched row

Is this something that would wwork for you?
http://www.myonlinetraininghub.com/e...ultiple-sheets

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1