A problem with serial numbers in cells.

[okanem]

Hi all, I have an issue with getting a serial number into a cell

A user can buy product A and product B.

Product A comes with a serial number, B doesn't but if A and B are bought together, Product A's serial number doubles up as Product B's

In the scenario below, John Doe buys Product A and B.

Our ERP system exports sales in csv format, the following is a simplified example

Row Name Product Serial #
1 John Doe Product A 00101
2 John Doe Product B

You see in row 2 the serial number is blank, but I need 00101 put in there based on the fact that the cell above is, (a) for John Doe and (b). has a serial number.

I can ofcourse simply copy and paste the serial number down into the Serial # cell in row 2 but sometimes there can be hundreds of names in a sales order.

Any ideas of how, possibly using macro's, can I get the serial number in based on the (a) and (b) criteria listed above.

I have attached a simple example of what I am trying to do

[DonkeyOte]

Possibly with something along the lines of:

Please Login or Register  to view this content.

[maybelle]

Maybe a combination of a couple vlookups and ifs?

[martindwilson]

how about in insert new col d then in cell d2
=IF(A2=A1,D1,C2) dragged down then copy paste/special values over column c then delete col d