I want to vlookup with supplier and product with other file "Comparing file" which has supplier and product. if value matches and status is completed , Mark as Yes in output
Supplier
Product
Status
Output
AB
XY-1
Completed
Yes
AB
XY-1
Completed
Yes
AB
XY-2
Completed
Yes
BC
ZA-1...