VLOOKUP Will NOT Work on my Date Columns

Hi @John- Michael Diedrich

I'm glad you were able to figure out the first issue!

For the second formula, is it possible that it's unable to find a match for your Site ID? To test this, try using a COUNTIF to simply COUNT how many times that item appears in your other sheet:

=COUNTIF({Site ID other sheet}, [Site ID]@row)

I would also suggest changing your formulas from a VLOOKUP to an INDEX(MATCH formula. This way you only reference two columns individually instead of on range spanning 20 columns.

A VLOOKUP can break if the columns in that range are swapped around, and it greatly increases your referenced cell limit (even though 18 of those columns aren't being used, they're still being referenced). See: Tips for working with references

An INDEX(MATCH works like this:

=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))

So in your case:

=INDEX({Column With Dates}, MATCH([Site ID]@row, {Column with Site ID}, 0))

Let me know if this has helped or if you're still receiving a blank response! If it's still not working, it would be helpful to see some screen captures of both sheets, but please block out sensitive data.

Cheers,

Genevieve

Hi @John- Michael Diedrich

Thank you for testing! A blank cell indicates that it is finding a Site ID match, but that the cell in your "Cut Over Date" column associated with that ID number is blank. Could that be possible? (Otherwise, it would return a NO MATCH error like your top row).

I also notice that your Site ID column has the values on the Left of the cell (indicating that they're seen as a Text string). Can you check to see if the StoreID column in your other sheet has the values appear in the same way, on the left?

I'm glad to hear it! 🙂