I have data in sheet 1 and sheet 2.
I’m trying to use a MATCH/INDEX/VLOOKUP formula, to find data in another column.
HOWEVER – instead of retuning the value or matching – I Just want to mark an X (or check mark etc).
Sheet 1 will be a simplified version that is printable for my fieldtechs.
Any help is appreciated!
All attempts only providing matches.
Working with Excel 2013 so possibly limited (VBA available).
New contributor
Dylan Steele is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.