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
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