Vlookup formula?

I'm pretty new to excel but think I've come a long way and have now reached my bump in the road.

I have a workbook with five sheets.
My first sheet is a "tracker" of sorts.

Columns D, E, F, and G have their title and right below (row 2) there are drop down menus with options corresoponding to the "title"

Ex.
D1=Category (title)
D2 (drop down) = "Activation" (an option) which a has a numeric value attached to it.

The formula =vlookup(D2, Sheet2!A12:B12, 2, FALSE) is attached to Column "I" which provides me with the amount earned from said "activation"

However, when I move on to D3 and select "Activation" Column "I" will not populate with the numeric earning.

Eventually columns D, E, F, and G will be added together and ideally populate column "I" (which I've managed to work, but only on one row.)

So I'm doing something wrong, I'm just not sure what.

Help would be greatly appreciated.

You have sample workbook? just try to upload it

Regards
Azumi

Originally Posted by azumi

You have sample workbook? just try to upload it

Regards
Azumi

Screen Shot 2013-12-05 at 12.16.29 AM.pngScreen Shot 2013-12-05 at 12.16.44 AM.jpg

Template.xlsx

I think this is what you meant. I misunderstood before.

=VLOOKUP(D2,Category!$A$1:$B$12,2,FALSE) , You just forget the dollar sign $ to absolut position of ranges

or see the file

Azumi

Originally Posted by azumi

=VLOOKUP(D2,Category!$A$1:$B$12,2,FALSE) , You just forget the dollar sign $ to absolut position of ranges

or see the file

Azumi

Definitely understand what you did but, am I going to have to enter the formula everytime in column "I?"

I opened the file and the D3 Selection does show the corresponding amount but when I go to D4 and make a selection it still does not autopopulate..

And how would I go about adding columns together w/o it giving me a !#value message under earned