benicholson100
New Member
- Joined
- Dec 5, 2019
- Messages
- 6
- Platform
- Windows
Hi,
I have a huge list of company names to which I need to assign a code. Some I have codes next to already and so I need to apply the same code next to the same company name, however, when I try, it picks up the first option of "Not Found", so returns that. Is there a way to exclude this specific return and populate with the 'code'?
Many thanks
Ben
I have a huge list of company names to which I need to assign a code. Some I have codes next to already and so I need to apply the same code next to the same company name, however, when I try, it picks up the first option of "Not Found", so returns that. Is there a way to exclude this specific return and populate with the 'code'?
Many thanks
Ben
Company | Code Found | Formula |
ABC Ltd | Not_Found | |
DEFG Inc | Not_Found | |
ABC Ltd | 5678 | |
DEFG Inc | 91011 |