SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW

R

RAZ

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
 
Top