I cant get this vlookup to work. I know its a format issue and have made the formats the same bus still doesnt work. Please advise. Thanks.
I cant get this vlookup to work. I know its a format issue and have made the formats the same bus still doesnt work. Please advise. Thanks.
Your dates in column H are not dates at all.
They're text strings becaue of the 2 digit day strings at the end (mo tu we etc..)
Remove those from the dates in column H and all will be well.
It is returning an #N/A because your dates are formatted incorrectly. The lookup date in column D is not matching to any dates in H.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Try this formula
=VLOOKUP(TEXT(D2,"mm/dd/yyyy")&"*",H$2:K$8,4,FALSE)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Keep the original format with this formula:
=VLOOKUP(LEFT(TEXT(D2,"mm/dd/yyyy ddd"),13),H2:K8,4,FALSE)
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks