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 matche...
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!