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