If statements inside Lookup function or use VBA to solve an issue

[eddthebed]

Hi,

I have two tables (using small ones as example) and I need to find values from one of them. Here is an example:

sample.xlsx

As can be seen, what I need is to find values for D2:D5 range. I am not sure what most efficient way to do this would be- use ifs or VBA? I tried to come up with code but am pretty new to these things so any help would be appreciated

Thanks in advance!

[CK76]

In D2:
=INDEX($E$9:$H$12,MATCH(B2,$D$9:$D$12,0),MATCH(C2,$E$8:$H$8,0))

[Pete_UK]

You have two values of 33 in column D - is this a typo? If not, then how should we choose between them?

Pete

[Tony Valko]

Here's another one...

=VLOOKUP(B2,D$8:H$12,MATCH(C2,D$8:H$8,0),0)

As Pete noted, there are multiple instances of 33 in the lookup table.

[eddthebed]

Thanks, =VLOOKUP(B2,D$8:H$12,MATCH(C2,D$8:H$8,0),0) is what I need!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Tony Valko]

You're welcome. Thanks for the feedback!