Question on search and replace

[mel9338]

Good Morning All,

Would like to seek assistance from anyone who can help to solve my issue.

I have a table with the following information

Column A - ID
Column B - Membership Number

Column C - ID
Column D - ID
Column E - ID
Column F - ID

Column A and B are related to each other.
How can I replace Column C, D, E and F with Membership Number when it found a match when compare to Column A?

Thank you in advance!

[Akuini]

Try this:

Please Login or Register  to view this content.

[FDibbins]

If you are looking to replace a cell's contents with data from another cell, you will need VBA for that, you wont be able to do it with formulas.

[mel9338]

Try this:

Please Login or Register  to view this content.

Good Afternoon Akuini,

It work! I've been looking for the solution for weeks!

Thank you very much!

[mel9338]

If you are looking to replace a cell's contents with data from another cell, you will need VBA for that, you wont be able to do it with formulas.

Do you mean that in general, anything that require the change of data in a cell that already contain existing data, it will require VBA?

[Akuini]

You're welcome, glad to help, & thanks for the feedback.

[FDibbins]

Do you mean that in general, anything that require the change of data in a cell that already contain existing data, it will require VBA?

Yes, that is correct. Formulas can only work on the cell they reside in, they "pull" info in. They cannot "push" anything to other cells.