ExcelBanter - Find text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find text (https://www.excelbanter.com/excel-worksheet-functions/216594-find-text.html)

Tia[_3_]

Find text

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

Best Regards

Glenn

Find text

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

Best Regards

Look he

http://www.contextures.com/xlFunctions02.html

All times are GMT +1. The time now is 12:29 PM.