Check Box if Name in another sheet matches name in current sheet.

Chris Benskin

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.

Paul Newcome

Are you able to provide some screenshots for reference?

Chris Benskin

Paul

The top screenshot is the Purchasing Log and the bottom one is a different sheet called Approved Supplier List.

I want to construct a formula where the Box in the ASL column of the Purchasing Log will be checked if the Vendor Name matches a Supplier Name in the Approved Supplier List sheet. If there is no name match the box in the Purchasing Log remains unchecked.

Paul Newcome

Ok. Try this...

=CONTAINS(Vendor@row, {Other Sheet Supplier Name Column})

Chris Benskin

It seems to be working but if there is no match the ASL check box column stays blank. Can something be done to show a blank check box in that situation?

Paul Newcome

This should work.

=IF(CONTAINS(Vendor@row, {Other Sheet Supplier Name Column}), 1)

Chris Benskin

@Paul Newcome Thank you. Works like a charm!

Paul Newcome

Happy to help. 👍️