Can you convert this vlookup to an index match or index collect?

basically, it rest id exists in both SS and on the other SS a field is either checked or unchecked, then result should read Yes.

=IFERROR(IF(AND(VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 1, false) <> 0, VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 39, false), 0), "", "Yes"), "")

the checked/unchecked box may have a note in it when means the result should read no.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!