| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value from Column B if above this row
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Return the column | Excel Worksheet Functions | |||
| Lookup in one column, and return value from another column | Excel Worksheet Functions | |||
| Search one column and return value from next column | Excel Discussion (Misc queries) | |||
| How to return value from last column w/value? | Excel Worksheet Functions | |||
Threaded Mode
