worksheet: 1

I have a list of ITEM#'s in column (A) and the coresponding STOCK LOCATION
column (B). The QUANTITY of each item is in column (C). The ITEMS are sorted
by STOCK LOCATION.

(A) (B) (C)
101398 1 120
101538 1 500
101398 2 50
101538 2 100

worksheet: 2

I want to do VLOOKUP of the ITEM#s(in columns A & C) to get the QUANITY
levels(in columns B & D), but I want to the formula in column (B) to only
look for the items the match the STOCK LOCATION the is in cell ($A$1). And
for column (D)'s formula to match cell ($C$1).

(A) (B) | (C) (D)
1 | 2
ITEM QTY level | ITEM QTY level
101398 120 | 101398 50
101538 500 | 101538 100