Index Match List Lookup - Multiple same values with condition

Hi guys,

Trying to make an index match function (not sure if that's the best function to use) that looks up a number and returns the value. The difficulty is, sometimes the same lookup value (i.e., number) is represented multiple times. For instance, in my data the number "103" is seen three times, but I need the index match to lookup each value different.


See dummy data
In essence, in the Output tab I want cells C5:c15 to lookup the number from D5:D15 in the data tab B35:L35 and return the value in B4:L4. Oh, and the code also has to match the output tab cell B3 (PY2) with the range in data tab B3:L3. So I guess its really match TWO variables and return the value.

Happy functioning guys! Thank you so much for the help, as always.

Buonasera
potresti mettere l'otput desiderato?

Sicuro! Output desiderato aggiunto alle celle B5: K15.

Sure, desired output added to cells B5:K15. See new dummy data

I don't see where that code also matches cell B3 with the data tab range B3:L3.

Also my dude, I use English functions, sorry. Any way you could use English functions and not Italian? My apologies!!!I can google translate most, but not all. Thank you.

Thanks Ali.

I'm still looking for an answer to this thread, if anyone can help. I need the output range (highlighted in yellow) to match cell B3 in range Data tab B3:L3 and match the number in cell D5:D15 to Data tab B35:L35 and return the value in data tab b4:L4. However, some of the values in cell D5:D15 can be repeated, for example "103" shows up three times. So that needs to be accounted for in the function because each "103" should have a different output.

Thank you!