I have a little table in Excel in cells A1:F5. In cell E9 to the right of my Formula Label I need a formula to evaluate the value in E7 (in this case A3) and evaluate the value in E8 (in this case 115) and read through the column headings to return a result of 3 PART. How can I write a VLOOKUP formula or INDEX(MATCH formula to do this? Thanks
1 PART 2 PART 3 PART 4 PART 5 PART
A3 100 110 120 130 140
A4 200 210 220 230 240
A5 300 310 320 330 340
A6 400 410 420 430 440
Code A3
Value 115
Formula
Bookmarks