Hi, this is my first time here. Im kind desesperate, my boss told me I should do something in excel for him and I dont know how to resolve it. I read about vlookup but I dont understand.
This is what I need:
Sheet ONE:
category: SENIOR
LOCATION TOTAL
GERMANY 900
FRANCE 1125
FRANCE 1125
USA 1400
Sheet TWO:
GERMANY FRANCE USA
Junior 1200 1500 1875
Senior 900 1125 1400
SemiSenior 600 750 1000
People should fill in the sheet one only the location and the formula should bring how much it cost, the total. The formula should see that the category (specified on the top) and see which is the location and bring the total from the table from sheet two.
Can somebdy please help me, or send me an .xls with the example working so I can copy it?
You would save my life.
Thanks you very mucho, hope to have answers.
ps: sorry for my english
Bookmarks