Hello, wonder if anyone can help with the following.
I have a sheet with data in cascade; meaning relevant data for cell A1 is in B2, C3, D4 etc.
Logically vlookup cannot be used normally. Is there any formula, which can return value in different row?
Attaching excel for example.
Bookmarks