K
KimC
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.
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.