View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Looking for a function that performs a special kind of Vlookup


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?