southern5footer
New Member
- Joined
- Sep 21, 2016
- Messages
- 9
I'm trying to find a non-vba solution to this problem and I've searched and searched online but I think I might not know the correct terms to search effectively.
I want to populate every row of column A with the correct name in column B. so A1&A2 are Frank, A3&A4 would be Leslie and A5 would be Joe.
Is there a formula that could look-up starting in the row your in going up until it gets a value?
<tbody>
</tbody>
I want to populate every row of column A with the correct name in column B. so A1&A2 are Frank, A3&A4 would be Leslie and A5 would be Joe.
Is there a formula that could look-up starting in the row your in going up until it gets a value?
| Row # | Column A | Column B |
| 1 | Frank | |
| 2 | ||
| 3 | Leslie | |
| 4 | ||
| 5 | Joe |
<tbody>
</tbody>
