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.


  • Thanks for your Like :thumbup:

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

Participate now!

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