terrydennis
Member
This is my first use of this website and when I found it I thought how good it was. Here is my problem.
I have been using INDEX & MATCH but struggling to get the syntax for the following scenario. Simplifying will enable my problem to be explained better.
I have a list of names in an Excel spreadsheet from , say A10:A20. They are not in alphabetical order.
I have one cell , say A1 , into which a name is entered. I want to look through the list of names to see if I can find the one that I have just entered and in cell , say , A5 put the located name or , if it does not appear in the list , put the message "Name not here"
Can someone please tell me what the expression should be ?
I have been using INDEX & MATCH but struggling to get the syntax for the following scenario. Simplifying will enable my problem to be explained better.
I have a list of names in an Excel spreadsheet from , say A10:A20. They are not in alphabetical order.
I have one cell , say A1 , into which a name is entered. I want to look through the list of names to see if I can find the one that I have just entered and in cell , say , A5 put the located name or , if it does not appear in the list , put the message "Name not here"
Can someone please tell me what the expression should be ?