hi, this is my first post so im sorry if its not done in the right place or maner, my problem is i need to get a lookup formula to look into a colum for a value and if that value is found to copy it to the same raw but in another colum:

look in Colum A for value 1:42 if that value is found in A3, A15, A45 then copy that value to B3, B15, B45. i hope im making myself understand and some good soul can help me out.

many thanks in advance.

Jorge