Offset Match (on another tab)

[Mandy_]

Hi,

I'm creating a contents page for a recipe book. And my excel workbook has tabs for each section (Contents, Breakfast, Lunch, Dinner etc), and my contents page has a list of all recipes in each section. 8 recipes for Breakfast, 12 for dinner etc). As my recipes are changing/adding more later in time - I'd like the contents page to dynamically update.

I'm able to match the title on the contents page to the Title of the recipe in the section, but am then unable to get the page number.

=match(i10,Breakfast!A:A,0)
where i10 is the recipe name.

The page number will always appear in column G - 44 rows below the Title name.

so if match = 3 then the page number is on G47

or if match = 97 then the page number is on G141

The contents page and the page of the recipe are in separate tabs.


I've tried offset match and index match - but am having some difficulty.

Thank you for your time,

 

[Fluff]

How about

=INDEX(Breakfast!G:G,MATCH(I10,Breakfast!A:A,0)+44)

 

[Mandy_]

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.