Creating an invoice - multiple inputs to pull from multiple return values

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.

In the next cell over from your drop-down (assume this is in A2, so we are talking about in B2) you can use this formula:

=IF(A2="","",CODE(A2)-64)

Hope this helps.

Pete

I will try that! Can you tell me what the "CODE(A2)-64" part is though? I've never seen anything like that. Also, can I repeat that within the same parens?

I want to be able to have that one formula look to see if the cell next to it says A, B, C, D, etc, and return a different value for each.

Thanks!

The CODE function returns the ASCII code of the first character in the cell - if this is "A" (without the quotes) it will return 65, for "B" it will be 66 etc., hence the reason for subtracting 64 from this value.

I don't know what your second paragraph means - perhaps you should attach a sample Excel workbook, to explain it more clearly.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work on this forum, so don't try to use that.

Hope this helps.

Pete

Thanks for that explanation!

Here's an example of my data I'm wanting to use. I want to be able to put anything from column A (the words) into a cell (A1 for ease) and have B1 return the corresponding numeric value (below) based on what was entered into A1. Does that make sense?

Ideally I'd love to have a drop-down or some other form to pull the information from Column A as my data is much more in-depth than letters. (Specific billing codes for my employer that there are so many of that I don't want to have to try to memorize and type manually each time.)

I can provide a basic Excel if that's easier, I'd just have to edit my current one so I don't infringe on any proprietary Information.

A 1
B 2
C 3
D 4
E 5
F 6

Yes it would be helpful to see a sample Excel workbook, which has the same layout are your real file even if the data in there is made up.

It would probably be easier to use a table of descriptions and codes, and then you can use a VLOOKUP formula to retrieve the appropriate code from a given description, but until I can see some realistic example data (and the say it is laid out) I can't suggest a specific formula for you to use.

Hope this helps.

Pete

Here, hopefully this attached.