Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Formula Please help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Formula Please help
Try this in C1:
=VLOOKUP(B1,Sheet1!$A$1:$B$100,2,FALSE) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Tia" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Formula Please help
Sorry, I missed the sheetname, that formula should be:
=VLOOKUP(B1,Scale!$A$1:$B$100,2,FALSE) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Tia" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
vlookup formula | Excel Discussion (Misc queries) | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
If / Vlookup Formula Help €¦!! | Excel Discussion (Misc queries) |