Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Kalibasa
Lv 4
Kalibasa asked in Computers & InternetSoftware · 6 years ago

Can someone help me with this VLOOKUP function error?

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!

3 Answers

Relevance
  • garbo7441
    Lv 7
    6 years ago
    Favorite 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
    Lv 7
    6 years ago

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

    then after H12000;

  • Kalibasa
    Lv 4
    6 years ago

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

Still have questions? Get your answers by asking now.