Index/Match Question


Hello. Looking for assistance with a formula. I am working off of 2 sheets. Sheet 1 is my Master Schedule and Sheet 2 is imported data containing (1) column of data only. The Primary column on both sheets is the Job Number field. What I'm hoping to do is run through all Job Numbers on Sheet 1 and if the Job Number is located on Sheet 2 I would like to checkmark the Exhibitor List field on Sheet 1. I cannot use vlookup as I'm already at the max limitation for that. Figured Index/Match would be the best bet, but not sure how to set the formula up. I would run newly imported data on Sheet 2 daily.

Sheet 1

Sheet 2

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!