Formula to reference multiple cell ranges?

Copper Contributor

Hi I would greatly appreciate any help solving a lookup formula I need.

 

I have inserted a screenshot where the yellow cell needs to return a date from row 5 if the "F'work" tag in column I matches those in column C and if there is a percentage figure in the date table i.e "BBB" in cell M6 has an uplift of 3%, so Apr-23 would need to be returned into the formula cell. 

 

NB. there will only be 1 percentage uplift per "F'work" tag.

 

Gkerr_1-1661436111723.png

Thank you

 

2 Replies

@Gkerr 

In D7:

=IFERROR(INDEX($J$5:$U$5,MATCH(9.99999999999999E+307,INDEX($J$6:$U$200,MATCH(D7,$I$6:$I$200,0),))),"")

Adjust the ranges if your data extend below row 200, then fill down.

You are a legend - thank you so much!