SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count # of cells with same value other column? 4
Set non-continuous PrintArea via Function / Name 0
SUMIF with criteria "<>" & "=" 4
SUMIF function help 4
SUMIF data that falls within a range 3
How to Control a formula by a character in adjacent column on same 4
Return next non-Blank Cell in a Column ? 4
don't know what function to use 2

Back
Top