Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Lookup by column and row values

I have a MxN table with first column and row used as labels

Sample table

Is it possible to extract value from such table having row and column label? For example, for row labeled "5" and column labeled "3,00%" resulting value will be "5,30914". I tried with VLOOKUP and HLOOKUP but these functions does not work for me, as they use column index, not value.

Lookup by column and row values

I have a MxN table with first column and row used as labels

Sample tablelabels (see https://imgur.com/a/n68oM for screenshot)

Is it possible to extract value from such table having row and column label? For example, for row labeled "5" and column labeled "3,00%" resulting value will be "5,30914". I tried with VLOOKUP and HLOOKUP but these functions does not work for me, as they use column index, not value.