Can someone help me with this VLOOKUP function error?

Question

I can't share this worksheet since it's private data, but I'm getting an error on a VLOOKUP formula and was hoping someone could help me!

This workbook is calculating interest on a thirty-year mortgage and has two sheets. The first sheet is called 'refi breakeven'. It has dates listed in column B (set to the date format, every day of the mortgage is listed). Column H has the interest paid being summed up day by day.

Since there are a lot of cells, on the second sheet, I'm trying to pull the value from column H ('total interest') that corresponds to the date 12/31/14, which is listed in column B. This is the formula I wrote:

=VLOOKUP(12/31/14,'refi breakeven'!B13:'refi breakeven'!H12000, 7, FALSE)

I tried this too:

=VLOOKUP(12/31/14,'refi breakeven'!B13:H12000, 7, FALSE)

I am getting a !N/A error message. Does anyone know what I'm doing wrong? I'm fairly new to Excel functions ;)

Thanks!

garbo7441 · Accepted Answer

Excel does not recognize '12'/31/14' as a Date.

Try:

=VLOOKUP(DATE(2014,12,31),'refi breakeven'!B13:'refi breakeven'!H12000, 7, FALSE)

Bill · Answer

try a semicolon after the date - 12/31/14;
then after H12000;

Kalibasa · Answer

Ah, that makes sense! And it worked. Thank you SO much

Can someone help me with this VLOOKUP function error?

Trending Questions