For your VLOOKUP formula the 2nd parameter (the lookup table) should start with the column that contains the information you are looking up (Column G, in this case), then count the columns to the right of that (including column G) to get the column index number to pull rate from.
=IF(Q11="","",VLOOKUP(Q11,$G$2:$N$1422,7,FALSE))
Note: I added the IF() statement so you don't show errors when the product is not yet chosen.
Similarly, the Amount column uses the IF():
=IF(Q11="","",V11*U11)
Bookmarks