CheckFAMEList.xaml (20.8 KB)
Invoice Data.xlsx (590.8 KB)
CosOver5Employees_UKEir.xlsx (10.3 KB)
I have the attached setup so that an Invoice list is inputted and it looks up the Company Name against a second list (“CosOver5Employees_UKEir”). Currently it just indicates if there is a match.
- When populating the column with Yes or No if it matches it overwrites the header. Is there a way to prevent this?
- Also, Is it possible to returned the actual value of the matched data? Thinking i may need to rebuild if it is going to do this.