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 !!
Bookmarks