That's because the formula will be changing the ranges you're
searching in, look carefully at what has happened when you drag it
down, you will see G1 has changed to G2 or G3 etc, as will all of the
cells you have dragged it to. You need to put a $ in front of the
cells you don't want to change.


=IF(AND(VLOOKUP($G$1,$C$2:$D$11,1,FALSE)=$G$1,VLOO KUP($F$2,$A$2:$B
$11,1,FALSE)=$F$2),VLOOKU**P($F$2,$A$2:$B$11,2,FAL SE),0)

Suggest getting a good excel book to learn the basics of this
otherwise it'll be slow going for you to do your spreadsheet.