What i am trying to do is

if i have 6 columns

A B C D E F

1 25 2 3 a P
2 22 5 4 b
3 24 3 10 g A
4 55 8 15 k
5 61 9 2 p
6 7 0 21 d

column A and B have related info. C and D HAS related info . I
want to see if any entry in column C matches any entry in B, Then the
corresponding row VALUE from D should be copied to a new column E in the
same Row as B

Eg

here C1 matches B3 ( value 3) then value D1 which is value a should be
copied to E3 which is same row as B3
C5 matches B1 so the value p should be copied to E 1.


Any help is appreciated.

"Manish" wrote:

What i am trying to do is

if i have 6 columns

A B C D E

25 2 3 a P
22 5 4 b
24 3 10 g A
55 8 15 k
61 9 2 p
7 0 21 d

column A and B have related info. C and D HAS related info . I
want to see if any entry in column C matches any entry in B, Then the
corresponding row VALUE from D should be copied to a new column E in the
same Row as B

Eg

here C1 matches B3 ( value 3) then value D1 which is value a should be
copied to E3 which is same row as B3
C5 matches B1 so the value p should be copied to E 1.


Any help is appreciated.