Excel Formula

M

Mithesh

I have datas typically numbers in 3 coloumns, i need to look up the number
from coloumn 3 with coloumn 2 and the corresponding coloumn1 number should be
copied to a new coloumn.

Which formula can I use?

For eg. coloumn 3 one of the number is 123456 the same no. exists in coloumn
2 also, but the corresponding row data of coloumn 1 might be 654321.. This
no. should be copied to the corresponding row of a new coloumn.


Thanks in Advance
 
Top