Formula to always return cell below what a vlookup would return

**KCHEXCEL** · 08-27-2013, 11:53 PM

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%

**NeedForExcel** · 08-27-2013, 11:58 PM

Please attach a sample workbook if possible

**protonLeah** · 08-28-2013, 12:02 AM

You should have posted a workbook. I can't tell whats in each column. If you do MATCH("John",B:B,0) it will return the row number, so, combining with INDEX you can use something like:
INDEX(C:C, MATCH("John",B:B,0)+1)