check a box across on another sheet

PeterLatcapital

I have a condition which is met on one sheet and I want to check a check-box on another sheet.

When a purchase request is updated in the {purchase request} sheet, column [vendor] = "LKQ" then check the box "Purchase requested" in another sheet the {Vendor Specific Sheet}.

Paul Newcome

Are you able to provide some screenshots for reference?

PeterLatcapital

On the purchase request sheet

On the Parts Procurement report which feed the individual vendor reports:

I need a formula to change a cell in the Parts Procurement Report: If the Claim Number (Not visible) and the vendor "LKQ" match from one sheet to the other, then check the box in [Adjuster requested Part Purchased].

Thank you, Paul

Austin Smith

Try this. Not 100% sure that does what you want it to.

Helper col. =if(vlookup([claim number]@row, purchase request sheet reference, vendor column, false)=vendor column on procument sheet,"true","false")

Austin Smith

ignore the helper column requirement at the beginning of the formula - rewrote to not need it. sorry

Paul Newcome

Since you want to match on two separate criteria and you are only wanting to check a box, you can use a COUNTIFS to find how many rows have the matching vendor and claim number. Then drop that into an IF statement to say that if that count is greater than zero, check the box.

=IF(COUNTIFS({Source Sheet Vendor Column}, @cell = Vendor@row, {Source Sheet Claim Number Column}, @cell = [Claim Number]@row)> 0, 1)

PeterLatcapital

Thank you for your help Paul. I will let you know.