IF Statement...I think

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a list of names in column A. In column E I have a list of letter codes to go with each name. I want to write a function to do the folllowing. Look for the letter P or S in Column E. when an Instance occurs I want it to copy the name and put it in a seperate worksheet.

Thank you for your time and effort
Steve
 
Say that the list is in Sheet1.
Say you want to "put" the names on Sheet2.

On Sheet2, in cell B1, enter the letter code for the name you want
displayed.
Enter this formula in Sheet2, where you want the name to be displayed:

=INDEX(Sheet1!A1:A21,MATCH(B1,Sheet1!E1:E21,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



i have a list of names in column A. In column E I have a list of letter
codes to go with each name. I want to write a function to do the folllowing.
Look for the letter P or S in Column E. when an Instance occurs I want it to
copy the name and put it in a seperate worksheet.

Thank you for your time and effort,
Steve
 
What If I want to use 2 letters and also blank cells. How do I modify the formula to reflect this?
 
Don't quite understand when you say "use 2 letters".

Do you mean 2 letters to obtain one name, or 2 letters to return 2 names at
once?

And what are blank cells supposed to do?
 
I would like the formula to look in column E for the letters P and S, and also any blank cells, if an instance occurs, I would like it to take it the name in the corresponding row and insert it in worksheet 2.

thanks for your help,
Steve
 
Back
Top