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
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