Check Box if Name in another sheet matches name in current sheet.
I have a Purchasing Log that lists Vendor Name among other columns. I'd like to put together a formula where if the Vendor Name matches Vendor Name in another sheet and if so, return a checked box and if not return an unchecked box. I have messed around with MATCH, IF and INDEX functions and cant get anything to work.
What is the best way to attack this issue?
Thank you in advance for any help.
Help Article Resources
Check out the Formula Handbook template!