If cell matches copy different cell

Administrative Note:

Welcome to the forum.

This is a free forum - people help as and when they will (we don't do 'urgent').

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

Untested, but try this, copied down:

Formula:

Please Login or Register  to view this content.

Or, for example, A2:A10 in one go:

Formula:

Please Login or Register  to view this content.

This cannot be used in a Structured Table.