I'm at work and have been assigned the task to create a spreadsheet with, what i consider to be, a complicated function.
Here's what im trying to do.
In Column B I have a list of codes such as:
40850
64500
55101
55102
55103
70706
and so on
Each code stands for a certain category.
For instance,
40850 is Fees
64500 is FICA
55101 is Medicare
and so on.
Right now i'm only using about 30 codes, but as I utilize this spreadsheet more in the future, I could use up to 100 of the codes.
I need a function so that when I type a code in Column B, the category for the code automatically pops up in Column C in the same row.
For instance
Column B, Row 8 = 40850
Column B, Row 9 = 64500
Then, when i type 40850 in B8, Fees will automatically be generated in C8.
I thought I had it figured out, but the problem comes up when Column B might look like this:
40850
64500
40850...
see how 40850, or any code might show up twice in the column? The function has to be able to work with that.
Out of the print area I have put in the codes in column G, and the categories in column H. Then, my plan was as I type in a code that I havent used yet in Column B, I will just add that code and category to column G and H, then put it in the function.
Can anyone help...please??
Thank you so much!
Bookmarks