Can I do a "L" shaped HLOOKUP or VLOOKUP?

[Gianpierpiero]

Hello, I would need your help for the following. I am setting up a table with with a list of government bonds in two columns, "ISIN" and "Weight". These two values are taken from another table like the one below. What I would like do to is to write "EUR Government" in, say A1, get the ISIN in B1 and the weight in C1. I have various tables for other types of bonds, so EUR Government would be my input.

Having the ISIN in B1 is easy: HLOOKUP(A1;F1:I100;5;FALSE).

The problem is the weight value, which is in column H in my original table: I would need to tell my HLOOKUP to give me the value in [row 5; column 3] from the lookup value, and not only [row5]. Is there a way I can do this sort of "L" shaped HLOOKUP adding a column parameter (or a row parameter in VLOOKUP, which is the same problem?).

 

[RoryA]

I think you want INDEX with two MATCH functions - one for the row and one for the column.

 

[Gianpierpiero]

I think you want INDEX with two MATCH functions - one for the row and one for the column.

Thank you RoryA,
that was my first attempt, but I had to copy-paste "EUR Government" at the top of columns H and I, which was not so beautiful to see.. Then my two MATCH are the specific ISIN code (which I had found with HLOOKUP, as per above) and this "EUR Government".
However, it works.