Use VLOOKUP with hidden columns

[xianwinwin]

Hi All,

I've been trying this trick for a while and couldn't get the result. I'm trying to get a value from a table (matrix) based on the LEFT value and the UPPER value. If I had no hidden columns VLOOKUP would do it right.

In the picture you could see the INPUT from the user: 6A and 15 and the requested result should be 1,765.

The VLOOKUP will not help because 15 is not the 'distance' from the value 6A (due to hidden columns). I'm looking to input the values as shown above.

Can anyone advise how to circumvent this?
THANK YOU

* attached qqq.jpg

[shg]

Please post workbook, not pictures, if you want help with Excel.

[DonkeyOte]

You can use INDEX & MATCH, ie:

Please Login or Register  to view this content.

the first match returns row_num and second match the column_num for use with INDEX range to return value from intersecting point

[xianwinwin]

Thank you DonkeyOte - this solved it!!!