If per chance you were to want to return 7, 6, 8, 5 instead of just 7 you
could do this.

Select M, N, O, and P. While still selected type in Bernard's formula
modified like this.

=VLOOKUP(K1&L1,A1:G3,{4,5,6,7},FALSE)

Now commit with Ctrl + Shift + Enter, which is an Array Enter. Excel will
put { } around the formula and you will have 7 6 8 & 5 in the four cells.

DayThu returns 2 1 9 7 in the four cells.

If you want to modify the formula later to accomidate new data you will need
to select all four cells and make the modifications and array enter again.

HTH
Regards,
Howard

"Ayo" wrote in message
...

Let say you have a table with columns A, B, C, D, E, F and you want to do
a
vlookup, but not the regular vlookup but one that takes into account
values
in columns A and B. For instance:

A B C D E F
Day Tue 2 4 3 3
Day Wed 7 6 8 5
Day Thu 2 1 9 7

Taking the 2nd row, I want to do a vlookup based on Day and Wed instead of
just using Day. Is there a function like that or any combination of
functions
that I can use to do this?