G
Guest
This is probably simply for you guys but here goes:
In Column A I have customers, Column B is blank and Column C is color paint
sold.
A B C
Joe
Black
Red
Jane
Green
Blue
Black
Bob
Grey
For uploading into our system I need Column B to have the customer's name
beside every colour so I want to say:
In Column B, wherever there is data in Column C, return from Column A the
customer name above that row. I need it to look up only the closest name
above it.
Good golly I hope I explained that right.
In Column A I have customers, Column B is blank and Column C is color paint
sold.
A B C
Joe
Black
Red
Jane
Green
Blue
Black
Bob
Grey
For uploading into our system I need Column B to have the customer's name
beside every colour so I want to say:
In Column B, wherever there is data in Column C, return from Column A the
customer name above that row. I need it to look up only the closest name
above it.
Good golly I hope I explained that right.