IF(copy information from cell to another cell)

[sirbonesalot1]

Hello I would like some help trying to figure out a formula. I am using excel 2010

I would want to be able to have the formula enter the info from 1 cell to another if the number entered in this cell matches another cell. This is how it looks

A B C D
Fuentes, Marta 81572
Herrera, Bryan 81575
Okafor, Alexander 81577
Piedrasanta, Eldyn 81578


I would like to be able to do is IF I enter the ID number under the B column in any other cell to copy the name next to it to another cell. for example: If in D3 I enter 81572 from B1 then I want the name Fuentes, Marta From A1 enter to C3, then if I enter 81577 from B3 In D8 then I want the name from A3 to be enter in C8.

I hope I explained this well

[Sam Capricci]

don't know if you have these requirements sporadically or together (like D3 and D8 or from D3 to D8 (each cell in between too)) but this should work in C3 and any other cells in column C.
=IFERROR(INDEX(A:A,MATCH(D3,B:B,0)),"")

[Pete_UK]

Use this in C3:

=IF(D3="","",IFERROR(INDEX(A:A,MATCH(D3,B:B,0)),""))

then copy down as far as you need to.

Hope this helps.

Pete

[sirbonesalot1]

Thank you so much it worked perfectly

[sirbonesalot1]

Thank you both of you... i actually tried both formulas and they both game the result that I needed. You saved me so much time