View Single Post
  #4   Report Post  
Dave O
 
Posts: n/a
Default 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.