Category: Excel
Excel Lookup Multiple Columns
Look up value based on a key field and a date that falls between two dates Formula:=LOOKUP(2,1/(G:G=A2)/(H:H<=B2)/(I:I>=B2),J:J)
Read More →Look up value based on a key field and a date that falls between two dates Formula:=LOOKUP(2,1/(G:G=A2)/(H:H<=B2)/(I:I>=B2),J:J)
Read More →