Help needed

  • Thread starter Thread starter okanem
  • Start date Start date
O

okanem

I have two sheets, one contains a list of lot numbers a quantity for
each lot number and a model number. In some cases the lot number can
have multiple quantities against it, i.e. rows 5 to 16 can all be lot
3, each row has a different quantity but the model number for each lot
number stays the same

The second sheet is a summary sheet where when you enter a lot number,
it a. sumif's the quantities for that lot number into a cell and b.
returns the model number for that lot number.

I have the sumif sorted, but I can't find which function will return
the model number. Can anyone help.

As usual, thanks
Okanem
 
Assuming Lot numbers in Sheet1, column A, model numbers in Sheet1,
column C, and your target lot number in Sheet 2, A1, one way:

=VLOOKUP(A1,Sheet1!A:C,2,FALSE)
 
Back
Top