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?