Checkbox/Vlookup

0

I have no idea how to do this: is it done conditional format, VBA, formula?

on one sheet i have 3 checkboxes (A, B, C) which I want to toggle based on the vlookup value of a client based on a call status.

Call status will only be 1, 2 or 3.(Sheet: Master_Territory)

Checkbox is on a seperate sheet. (Account_Summary)

If Call status is = 1 then toggle check box in A1

If call status = 2 toggle a2

if call status = 3 toggle a3

Answer
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login