I am sorry I dont understand.

How would I write the formula to find the following:
Spreasheet 1 Spreadsheet 2
SKU Warehouse Qty SKU Warehouse Qty

13 CA 15 13 CA
(formula to copyt to
14 CA 30 14 HN
to each cell, ie
15 CA 18 13 HN
match column a & b
13 HN 10 14 CA
of spreadsheet 1 to
14 HN 5 15 CA
column a & b of

spreadsheet 2 to

find qty)
"Dave O" wrote:

I think I get you: you need to lookup to populate the QTY information
to the second spreadsheet. You can use the formula I posted in the QTY
column on the second sheet- the ranges, currently A2:A6, B2:B6, C2:C6,
should refer to the first sheet and the 13 and "CA" can refer to cells
on the second sheet.