Vlookup formula?

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..