SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
 

I am looking for a formula that is very similar to sumif - except I do not
what to sum the values - i just want to display the value or text that is
contained in another cell on the sam row that the name is on.

for example:
a1:a3 = joe, jane, rick
b1:b3 = 10,11,na
if "jane", then 11
sumif works if it's a value but how do I handle if "rick" then na?

I hope this makes since.

Thanks

SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
 

Try this:

D1 = jane

=VLOOKUP(D1,A1:B3,2,0)

Biff

"RAZ" wrote in message
...
I am looking for a formula that is very similar to sumif - except I do not
what to sum the values - i just want to display the value or text that is
contained in another cell on the sam row that the name is on.

for example:
a1:a3 = joe, jane, rick
b1:b3 = 10,11,na
if "jane", then 11
sumif works if it's a value but how do I handle if "rick" then na?

I hope this makes since.

Thanks

SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
 

Perfect- thank you


"RAZ" wrote:

I am looking for a formula that is very similar to sumif - except I do not
what to sum the values - i just want to display the value or text that is
contained in another cell on the sam row that the name is on.

for example:
a1:a3 = joe, jane, rick
b1:b3 = 10,11,na
if "jane", then 11
sumif works if it's a value but how do I handle if "rick" then na?

I hope this makes since.

Thanks

SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW
 

You're welcome. Thanks for the feedback!

Biff

"RAZ" wrote in message
...

Perfect- thank you


"RAZ" wrote:

I am looking for a formula that is very similar to sumif - except I do
not
what to sum the values - i just want to display the value or text that is
contained in another cell on the sam row that the name is on.

for example:
a1:a3 = joe, jane, rick
b1:b3 = 10,11,na
if "jane", then 11
sumif works if it's a value but how do I handle if "rick" then na?

I hope this makes since.

Thanks