How do you perform a two-column lookup?
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.
|