#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 79
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find repeated text in a text document in Excel JE Excel Worksheet Functions 2 June 8th 08 09:32 PM
Search, find or lookup defined text in text string zzxxcc Excel Worksheet Functions 9 September 6th 07 09:37 PM
find text in cell and replace it with part of the text in that ce. jules Excel Discussion (Misc queries) 3 May 3rd 07 10:18 AM
Find text within cell then display text to left Jambruins Excel Discussion (Misc queries) 5 April 17th 06 10:01 PM
can you find specific text in a string ignoring any other text chriscp Excel Discussion (Misc queries) 1 September 18th 05 09:54 PM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"