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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value from Column B if above this row
Copy Column A to Column B.
Then select the data in Column B, down to the same row number that has the last color, then: Hit <F5 Click on "Special" Click on "Blanks" Then <OK Type the equal (= ) sign Hit the UP ARROW Hold down <Ctrl, and hit <Enter -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CathyH" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value from Column B if above this row
In B1 enter:
=A1 this will pickup the first customer name In B2 enter: =IF(A2="",B1,A2) and copy down -- Gary''s Student - gsnu200721 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value from Column B if above this row
This works for the most part except that I have blank rows (these change
every time I generate the spreadsheet) so it's not returning the value for every cell that has a colour. Any other ideas? "Gary''s Student" wrote: In B1 enter: =A1 this will pickup the first customer name In B2 enter: =IF(A2="",B1,A2) and copy down -- Gary''s Student - gsnu200721 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value from Column B if above this row
This worked for me, however, I need to make the spreadsheet so the user will
not have to do any copy/paste. I needs to return the value automatically or there is too much chance for error. I'm learning a lot today - thanks! "Ragdyer" wrote: Copy Column A to Column B. Then select the data in Column B, down to the same row number that has the last color, then: Hit <F5 Click on "Special" Click on "Blanks" Then <OK Type the equal (= ) sign Hit the UP ARROW Hold down <Ctrl, and hit <Enter -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CathyH" wrote in message ... 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. |
Reply |
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 |