SUMIF for text
 

I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be no
duplicates.

What I think I need is an if function that works similar to the sumif function

SUMIF for text
 

You probably want Vlookup. There's a good explanation in Help. Post back if
you need more.

Regards,
Fred.

"bazsil,73" wrote in message
...
I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be
no
duplicates.

What I think I need is an if function that works similar to the sumif
function

SUMIF for text
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bazsil,73" wrote in message
...
I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be
no
duplicates.

What I think I need is an if function that works similar to the sumif
function

SUMIF for text
 

It sounds like you want to use =vlookup() or =index(match()).

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

bazsil,73 wrote:

I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be no
duplicates.

What I think I need is an if function that works similar to the sumif function

--

Dave Peterson

SUMIF for text
 

Home Place a
South Place b
Chuck c
Janie d
Eighty e
Ansutz f
Riggin North g
Riggin South h
Rowe i
Booth j
Flora k
Extra 2 l
Extra 3 m
Extra 4 n


"bazsil,73" wrote:

I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be no
duplicates.

What I think I need is an if function that works similar to the sumif function

SUMIF for text
 

It is still not clear what you want??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bazsil,73" wrote in message
...
Home Place a
South Place b
Chuck c
Janie d
Eighty e
Ansutz f
Riggin North g
Riggin South h
Rowe i
Booth j
Flora k
Extra 2 l
Extra 3 m
Extra 4 n


"bazsil,73" wrote:

I want the ability to search a range of cells on a separate tab but
instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be
no
duplicates.

What I think I need is an if function that works similar to the sumif
function

SUMIF for text
 

The VLOOKUP achieved what I needed. Thanks.!

"bazsil,73" wrote:

I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range.

Each cell in the range will contain unique text (names) and there will be no
duplicates.

What I think I need is an if function that works similar to the sumif function