VLOOKUP using flag or checkbox

How do I use VLOOKUP with Flag as the search value?

I tried the following:

=VLOOKUP("Checked", {Range 2}, 3, 0)

=VLOOKUP("checked", {Range 2}, 3, 0)

=VLOOKUP("true", {Range 2}, 3, 0)

=VLOOKUP(true, {Range 2}, 3, 0)

=VLOOKUP(1, {Range 2}, 3, 0)

All of the returning #NO MATCH even if there is a row that has a Flag checked.

Here's a screenshot of the lookup table:


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!