hi,
i know this might be an stupid question but, here goes..
for example i have this
A B C D
123 a 789
456 b 222
789 c 123
432 d 456
here's what i want to accomplised
A B C D
123 a 789 c
456 b 222 d
789 c 123 a
432 d 456 0
i need to compare value in cell A with every cell in C column, if match then cell d value is the cell b(column) value
if nothing match then 0
please could somebody enlight me,
i'm new to this formula thingie
i know this might be an stupid question but, here goes..
for example i have this
A B C D
123 a 789
456 b 222
789 c 123
432 d 456
here's what i want to accomplised
A B C D
123 a 789 c
456 b 222 d
789 c 123 a
432 d 456 0
i need to compare value in cell A with every cell in C column, if match then cell d value is the cell b(column) value
if nothing match then 0
please could somebody enlight me,
i'm new to this formula thingie