I copied the lookup values to column A on sheet1. I copied the cells I want
to see if there is a match in to column B on sheet1. I copied this formula
to column C where I want to see if there is a match or not.
Am I supposed to have a value in column D or can I only have 3 columns? to
make it work or should I just use a lookup instead of a vlookup? It seems
impossibly hard to do the vlookup directly on the sheets themselves so I
copied the columns to a new sheet. I still can't get it to work. I think
the vlookup is not very intuitive. Unfortunately I have all these sheets I
have to find matching values. I would like to understand it.