Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Vlookup and match seem to be searching based on the function I have in my cell rather than the value i have in the cell. I have a column with dates, (ex: C2, which has the formula =E2&"/"&F2&"/"&D2 in them, for example). (where E2, F2, D2 are the year, month, and date).

In another sheet and column, I have a bunch of dates, and i'm using the formula

=VLOOKUP(C2,'sheet2'!A1:B252,2,FALSE), which doesn't work. (returns #N/A)

If I replace C2 with the same date, but without the formula (just typing it in), VLOOKUP works. Why is this?

share|improve this question
up vote 1 down vote accepted

Replace this formula

=E2&"/"&F2&"/"&D2

with this

=DATE(E2,F2,D2)
share|improve this answer
    
That worked like a charm, thanks! – Brandon S. Apr 11 '12 at 8:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .