VLookup #N/A Value in Table

  • I have been trying to figure this out for the longest time and I've finally given up.

    The end goal is to have the Starting Budget autofill with the last Ending Budget amount based on what is in the Line Item.

    The formula I'm using is =VLOOKUP(B11,B3:F10,5,TRUE) see E11.

    Sometimes it works correctly, like when Hydro is entered into B11, but it shows #N/A when Audible is entered and pulls up the wrong amount when Phone is entered. I must be missing something obvious.

    Any help would be appreciated.


  • Hello and Welcome to the Forum :)

    Attached is your test file

    Hope this will help



    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)