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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!