View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KimC KimC is offline
external usenet poster
 
Posts: 52
Default Lookup with two lookup values

I have two sheets one sheet I heap of information
For example something like this:

A B C
1 CODE QTY DATE
2 1212 2 1/09/2008
3 2323 12 26/08/2008
4 3434 5 1/09/2008

On another sheet I want to in B2 find the QTY when you match the Code (in
column A - see below) & Date (in Row 1)

A B
1 1/09/2008
2 3434

Please help with any suggestions.