Hello,

Is it possible to set a formula to in column c to look at column A and if it has a value, go up to the last or previous blank cell, then go to column b and return the value and the corresponding row value. For example:

Column A Column B Fromula Result
<Blank> Dog
3 cat Dog Cat
6 Bird Dog Bird
<Blank> Cow
7 Snake Cow Snake
9 Horse Cow Horse



Thanks for the help!