Hi,
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?
Thanks!
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?
Thanks!
Last edited: