LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
More vlookup questions (I think?)(kind of long) JaimeZX Excel Discussion (Misc queries) 3 February 18th 09 09:17 PM
vlookup performs inconsistently with decimals in lookup value form Oxo New Users to Excel 2 November 17th 07 06:15 PM
Kind of a reverse vlookup sam Excel Worksheet Functions 4 May 7th 07 06:19 PM
Go to Special or other function to jump to vlookup source? andy62 Excel Worksheet Functions 0 August 6th 06 06:54 PM
Some kind of vlookup required? tcpeterso Excel Discussion (Misc queries) 4 May 19th 06 03:15 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"