This is my first post here sorry if i didn't do something right
i have a list of actions in A1:A20. if a certain action happens i need the value from column B to its right displayed in my cell (but only the most recent action)
doc77.xlsx
A ...... b ............. 77 displayed in this cell because A1 "test" is most recent found and 77 is the value next to it.
test ...... 77
no ...... 1
no ...... 2
no ...... 3
test ..... . 66
no ...... 2
no ....... 5
test ........ 55
Bookmarks