Vlookup - Two lookupvalues - complex

[cpsnuggle]

Hi,

I have below table of which I need to apply the Vlookup function to get my input right.

I have my Table_Array which contains Code, Name, Number & Currency. I need my function to be able to distinguish between numbers. E.g. If I type 100 in lookup value it would just return the first line which matches 100. But as seen in the table_array, there are different numbers for the same code. So what I essentially need is the function to call the written number, when I manually type in the code (Lookupvalue_1) and the currency (lookupvalue_2)

Thanks in advance

 

[cpsnuggle]

Epic man! Thanks so much.

 

[Alex Blakenburg]

No problem, glad we could help.