Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Text
I'm trying to create a formula in I will reference a cell with text in it and
then look through a table to find if it is found. Basically it is going to be used to find whether a first and last name is found on another table. Thanks and hopefully this is clear. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Text
sounds like you may want either VLOOKUP, INDEX or SUMPRODUCT. Are you saying
your referenced cell is an entire name and you need to find the first name and last name in a separate table? Will your referenced cell ALWAYS be first name and last name? Will some have middle names? Will any have just middle initials? Will there be any with a dual last name (Smith Johnson)? "Arock" wrote: I'm trying to create a formula in I will reference a cell with text in it and then look through a table to find if it is found. Basically it is going to be used to find whether a first and last name is found on another table. Thanks and hopefully this is clear. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Text
It is not clear.
Give us a cell reference that would contain text. e.g. A1 contains the word Arock Smith What is the table range you are looking into? e.g. D1:M32 What text is contained in cells in that table? Arock Smith is found by itself or as part of a longer string? Could it be found more than once? Gord Dibben MS Excel MVP On Mon, 31 Aug 2009 13:30:01 -0700, Arock wrote: I'm trying to create a formula in I will reference a cell with text in it and then look through a table to find if it is found. Basically it is going to be used to find whether a first and last name is found on another table. Thanks and hopefully this is clear. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in free-format text field | Excel Discussion (Misc queries) | |||
Find repeated text in a text document in Excel | Excel Worksheet Functions | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) |