Lookup a value in a table based on the row and the column fields

robyrux

New Member
Joined
Oct 29, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
I have a 2-dimensional table and I need to select the value based on the values of the row and the column. A sort of (X,Y) coordinate as input and as output the text that is contained in the X,Y cell.
Example below
abcd
1applepearmango...
2tomatosalad...
3

For the combination (a,2) I need to be able to extract tomato.

The rows and columns cannot be sorted to perform a vlookup.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,574
Office Version
  1. 365
Platform
  1. Windows
Maybe
+Fluff v2.xlsm
ABCDEFGHI
1
2applepearmango...Row2tomato
3tomatosalad...Col1
4
Main
Cell Formulas
RangeFormula
I2I2=INDEX(A2:E4,H2,H3)
 
Solution

robyrux

New Member
Joined
Oct 29, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Thank you, it requires an additional mapping but then it works!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,574
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,663
Messages
5,626,163
Members
416,166
Latest member
Archimed

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top