Vlookup w/ Checkboxes
I'm trying to link two sheets via a Vlookup equation. I want the formula to search the indicated sheet for an unchecked box and return whatever column I indicate.
I can make my equation work if I substitute numbers instead of checkboxes but I cannot make it work if I look for a check/unchecked box. What am I missing?