index match function on multiple worksheet

[maeyks]

hello,

can i actually use match-function looking for a single item if it is located on multiple worksheets?
thank you.


Mike

 

[Special-K99]

Use nested MATCH within IFERROR, e.g.

=IFERROR(MATCH(A1,Sheet1!A1:A100,0),IFERROR(MATCH(A1,Sheet2!A1:A100,0),IFERROR(MATCH(A1,Sheet3!A1:A100,0),... etc )))

Return index if A1 is found in Sheet1, if not
return index if A1 is found in Sheet2, if not
return index if A1 is found in Sheet3, ...etc

 

[maeyks]

Hi

Its like this. In sheet 1, I have the following:

lasagna pasta (noodles)
strawberry cheesecake (cakes)
lemonade (beverage)
savory pie (pies)

the RECIPES for the 4 abovementioned items are in worksheets 2 to 5, respectively. To avoid using index match function with different formulas, can there be a single index match function formula that will look into all of these four recipes and return the value

In effect I can write all my recipes categorically among the four worksheets but the first worksheet will have all the centralized items

Hope I make sense

Thank you