Hi there! I know this should be simple, but my brain just isn't working with me.

I'm trying to make an invoice template where I have multiple values that I will select, preferably from a drop-down menu I created (items labeled with A, B, C, D). If I select A, I want it to return the value of 1 in the next cell over, B return 2, C 3, etc. I have all of this information already in both a table and a pivot chart on a second tab, but that's where my brain is shutting down and I don't know what the easiest and most appropriate way to make this work would be.

Any help is greatly appreciated.