Formula to Show in a cel the values of a column per the value from another column.

[wcedeno]

I know how to make one cell to show the value from from B1 if I insert the value from A2, I use this formula =IF(D2=A2,B2,"UNDEFINED") this formula says, If D2 has the value of A2 then put the value of B2, if not the put undefined, until this point I am fine, the formula I really need should make something like this.

IF D2 is One value from A2:A50 then put the correspondent from B2 to B50, if not put UNDEFINED.

Can anyone help?

attached is the document.

Thanks

[MarvinP]

In E2 put this formula

=IFERROR(VLOOKUP(D2,$A$2:$B$50,2,FALSE),"Undefined")

I think that is what you want?

[wcedeno]

In E2 put this formula

=IFERROR(VLOOKUP(D2,$A$2:$B$50,2,FALSE),"Undefined")

I think that is what you want?

Yes, Thank you very much!