Microsoft Windows xp professional w/serv...

I want to automatically add different codes in a blank column, depending what is in another column. There are 19. Example:

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 choicesWhat can I do to create this?

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-xxIn 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.

Thank You that was very helpful and will make life eaiser.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History