Why is VLOOKUP returning wrong data???

Nicole Hanik

Here is the formula

=IFERROR(VLOOKUP([Primary Column]@row, {Foreman Pre Job Checklist Range 1}, 2, true), "Missing")

Should be returning 10/26/2020 but its pulling 10/20/2020 instead.

Also tried the formula with false but then it represents "Missing" as indicated in the formula

Formula is in the bottom picture, referencing top picture

John Jonassen

Hi @Nicole Paulsen

The False within the VLOOKUP expression is the part that gives you an exact match versus the True giving you a "close" match. What's considered "close" is, I guess, up to the program language.

Anyway, you should be using the following:

=IFERROR(VLOOKUP([Primary Column]@row, {Foreman Pre Job Checklist Range 1}, 2, False), "Missing")

Now, the next part you might want to look into is, is B645572 listed multiple times within your Foreman Pre Job Checklist range?

Nicole Hanik

Thanks @John Jonassen I changed back to be False but not it gives me "Missing"

I checked the sheet, there are no duplicates

John Jonassen

@Nicole Paulsen , well that's not what we want.

So, the other things I would check is to maybe re-establish your Foreman Pre Job Checklist Range, just to make sure your Primary is your first column and your Created Date is the second column within that range.

Maybe also verify that there are no trailing spaces which would cause it to be "B645572 " on one list and "B645572" on the other, which may result in your "Missing" result.

Nicole Hanik

@John Jonassen No go :(

I even tried putting a brand new line on the Pre Job Checklist and still nothing. I copied and pasted the primary from one to the other and nothing.

I am at a loss!

John Jonassen

@Nicole Paulsen , ok so maybe this is silly....because I just did it as I tried to recreate this to work with you...I accidentally selected the wrong sheet while establishing my Range...might not be the case but is the last thing I can think of.

Nicole Hanik

Well, i deleted the column entirely and started over.... That seemed to work. Very strange

John Jonassen

Very hokey! I'm glad you got it to work in some way.