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

kent.robinson

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.

Paul Newcome

Try this:

=IF(IFERROR(INDEX({Source Sheet Check Column}, MATCH([Restaurant ID]@row, {Source Sheet ID Column}, 0)), "") = true, "Yes")

Paul Newcome

Try this:

=IF(IFERROR(INDEX({Source Sheet Check Column}, MATCH([Restaurant ID]@row, {Source Sheet ID Column}, 0)), "") = true, "Yes")

kent.robinson

thank you sir. this certainly pointed me in the right direction and a reminder that index match inherently checks to see if something already exists.