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