Hello all. New to the board. I'll get right to it...
I'm trying to do VLOOKUP with multiple criteria (or maybe I should do INDEX or MATCH?). In the attachment, I want to place the argument in the cells C11 and C12.
So that in Table 2, if you enter ABC in the "Letters" column and 6/1/2011 in the "Date" column, it knows to go into Table 1 and grab 15. If it's ABC and 6/5/2011, then it's "81", etc.
I'm pasting the two tables from the attachment to the body of this post thought I'm not sure if it's going to be readable. Thanks!
Table 1
ABC DEF GHI
6/1/2011 15 29 18
6/3/2011 42 66 22
6/5/2011 81 82 44
Table 2
Letters Date Amount
ABC 6/1/2011 ???
ABC 6/5/2011 ???
Bookmarks