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