Index Match on Columns and Rows

Jan 22, 2013
Reaction score

I've been struggling with putting together a lookup formula. In the attached example, the Final Output tab is what I need to populate (cells B5:U8). As an example, the data I need to show up in B5 comes from D4 on the FYTD tab. There is a different tab for every time period, so the criteria I need to match for the FYTD columns are Product, Measure & Channel.

Product name is in A3 and it's match will be in column A on FYTD Tab
Measure is in row 4 and match will be on row 2 on FYTD Tab
Channel is A5:A8 and match is going to be on row 1 on FYTD Tab

I've been playing around with an Index Match formula and have moved around the row/column references to different positions in the formula, but nothing has helped.

Can someone help me figure out what I'm doing wrong?

Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question