VLOOPUP Formula help

Good Morning,

I'm trying to get a VLOOPUP function to work with 2 variables but it's not working. I have attached a file.

In Column A, I have Bag Sizes: 0.5, 4.99, 6.99, etc and these bag sizes are repeated depending on the seasoning

In Column B, I have Seasoning: LREG, L HOT, L BQQ, etc

In Cell "F5" I have a drop down list with Bag Sizes to Choose from

In Cell "G5" I have a drop down list with Seasonings to Choose from

In Cell "F11" I have formula:=VLOOKUP(F5&G5,A2:C86,3,0) but I'm not always getting #N/A as a results.

Any help would be appreciated, just trying to make work life easier! Thanks!

Use AVERAGEIFs: F11 = AVERAGEIFS(C:C,A:A,F5,B:B,G5)

bordemkills's data has repeat items.. SUMIFS will give wrong info.

Originally Posted by josephteh

bordemkills's data has repeat items.. SUMIFS will give wrong info.

I used the Averages!