You can use sumproduct to do something close to what you want. It is similar
to a sumif with multiple criteria. It will sum all of the records where it
finds both Day and Wed. Auuming there is only 1 unique instance then you will
get back the number similar to a Vlookup

=sumproduct(--(A2:A10="Day"), --(B2:B10="Wed"), C2:C10)

will return 7...

Here is a link to sumproduct...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

The author of that page is Bob Phillips who regularily posts on this site.
If this post is helpful buy him a beer.
--
HTH...

Jim Thomlinson


"Ayo" wrote:


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?