Dec 02 2018 03:57 PM
Your table_array (containing strings like "From 1 to 499") violates the rules for a vlookup function. You are trying to find a number among text values. Is it possible to change the change the table_array so that values in the left column are:
1
500
1000
1500
That would make the vlookup function work properly. Assuming your Quantity value of 1 for Donald Duck were in cell C3 and the name of table_array were "Range", your vlookup function could be =vlookup(c3,Range,2,true)
Dec 02 2018 10:07 PM
Thank you