Automatically Fill Cells

Microsoft Windows xp professional w/serv...
July 27, 2010 at 11:54:47
Specs: Windows XP
I want to automatically add different codes in a blank column, depending what is in another column. There are 19.

If Column C is 2915 then in column E enter 4500-51.
If Column C is 5241 then in column E enter 4500-22
If Column C is 6368 then in column E enter 4500-53
and so on totaling 19 different choices

What can I do to create this?

See More: Automatically Fill Cells

Report •

July 27, 2010 at 12:15:17
Start by creating a table with all of your values and corresponding codes.

Let's say you put this in A1:B19

     A         B
1   2915    4500-51
2   5241    4500-22
3   6368    4500-53
19  xxxx    4500-xx

In E1 enter this formula:

=VLOOKUP(C1, $A$1:$B$19, 2, 0)

Please refer to the Excel Help files for VLOOKUP to see how this formula works.

Report •

July 27, 2010 at 13:22:53
Thank You that was very helpful and will make life eaiser.

Report •

Related Solutions

Ask Question