Excel vlookup is super usefull, but I can never remember how to use it. So it’s always a struggle, and wastes a lot of time.
So we have a small table with parts, on a sheet named “primary: Note that the last “Exists” column is empty, we wish to populate this from another sheet.
Now we have another table, on a sheet named “other”: So we want to make a star in the exists column of the first table, if that partnumber is present in table two.