VLOOKUP Formula Please help

T

Tia

I am working on a data entry scale
I have two sheets the first sheet is called scale
Scale= A1 Job Title
B1= Grade
C1= Benefits

And i have another sheet that is called aplicant for the job offer
What i need is

A1= Employee Name
B1= Job Title
C1= ??????????
I want whenever i write the job title i get the grade from Sheet
"scale" automaticly
I know that i should use VLOOK UP i am having an error

Please help

Best Regards
 
J

JBeaucaire

Sorry, I missed the sheetname, that formula should be:

=VLOOKUP(B1,Scale!$A$1:$B$100,2,FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find text 1
Vlookup and Indirect 0
Need help with formula 2
Another VLOOKUP Problem 8
Vlookup help 5
vlookup and multiple ifs 4
How do I set up vlookup formula. 1
<<Need Formula For Lookup With 2 Variables>> 3

Top