vlookup for two columns

Joined
Apr 20, 2011
Messages
1
Reaction score
0
A B C ---------------------------------------D -----04/19/11 04/20/11 04/21/11

22 john 04/19/11 --------------------------------22 ------04/19/11 04/20/11
23 susan 04/19/11
22 john 04/20/11
24 rico 04/21/11
21 new 04/19/11


please help me how to come up with look like this.

lookup value is in column D ("22") and those dates above on the first line (beside D). table array is A1 to C1..
as we can see, entry of john is two.. what formula will i put to match on D1 and date header using A1 to C1 as table..

thanks.
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missed Opportunity 3
Find then highlight in yellow 6
Modifying a complex date formual to count months 4
SUMIF or COUNTIF 1
Windows 7 Duplicate files. 1
Combining functions 2
Time query 9
Database issue 2

Top