Multiple Lookup

[MCII]

I am trying to create a lookup that will evaluate two variables. From "sheet1" lookup the first variable which can be considered a unique acccount (this would not change), and the lookup for the second variable is a date (which would change). The source of the lookup will be "sheet2" (example attached). In that example the desired result is 4.375 Tried various iterations but none work. Thoughts anyone?

[tigeravatar]

MCII,

In cell D2:
=VLOOKUP(C2,Sheet2!$A$2:$N$2,MATCH(B2,Sheet2!$A$1:$N$1,0),FALSE)

Adjust the vlookup range (Sheet2!$A$2:$N$2) to suit

[MCII]

That solves it! Thanks for you help.