Hi
i want the formula for Vlookup the first non-blank cell and retrive the adjcent data
Data
A blank
B 2
C 3
A 4
B 5
C 6
Spreadsheet (desired result)
A 4
B 2
C 3
In Speadsheet, I want a formula to get the first column value (i.e. A), and vlookup for the first non-blank cell in data sheet and return the adject cell value(ie. 4)
thanks in advance
Bookmarks