Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tough lookup question
I think this is complicated but here goes:
I have a spreadsheet that looks like this: col1 Col2 Col3 bunch of junk more junk NUMBER #1234 firstname lastname This repeats over and over. What I would like to do is populate col3, when col2 is not null, with the value of the closest previous row that has NUMBER #9999. Does anyone know a formula or code to do this? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A tough macro question | Excel Discussion (Misc queries) | |||
Can anyone help with this tough question? Format Conditional | Excel Worksheet Functions | |||
*Tough Math Question* | Excel Worksheet Functions | |||
Tough conditional formatting question | Excel Discussion (Misc queries) | |||
Tough question | Excel Discussion (Misc queries) |