I'm working with spreadsheets where data and values are all across one row, and below the values in the next row are the corresponding %'s of budget achieved (usually these are just in the next column - easy!). As these spreadsheets aren't mine I don't want to manipulate any data, was just hoping there would be a formula that could return the cell below one that I would do a normal vlookup for (to give me the % rather than the $ value). Is this possible? Thanks for any help you can provide.
EG: How to return the cell below =VLookup("John",A1:C4,3,0)
A B C
1 JOHN 0.5 $50,000
2 SYDNEY 88%
3 PETER 1.0 $120,000
4 MELBOURNE 94%
Bookmarks