Vlookup w/ Checkboxes

tb18
tb18
edited 12/09/19 in Smartsheet Basics

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?

 

Comments