Forum Discussion
Formula to reference multiple cell ranges?
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.
Thank you
2 Replies
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!
