If a cell equals another cell, then use the value in the cell to theright.

[dicko1]

Thanks in advance for any help.

Column A Column B Column C Column D
Bob Steve 5
Steve Phil 10
John Ryan 1
Sara 6
John 10
Jane 11

I would like column B to search the range of Column C and if the name
in Column C match the name in A, then enter the value in Column D.

I figure its close to =if(A2=C2:C7, D2;D7, 0)

 

[Max]

Reframe it like this in B2: =index(D$2$7,match(A2,C$2:C$7,0))
Copy down

 

[dicko1]

Reframe it like this in B2: =index(D$2$7,match(A2,C$2:C$7,0))
Copy down






- Show quoted text -

Thanks, works perfectly.