Vlookup

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)