If, Then, Lookup? Excel 2010

ddw23

New Member
Joined
Aug 23, 2010
Messages
1
Hello I have a large worksheet and I need to input category codes in one column based on certain description words in another column. Example: If column D contains "cleaning" then enter "12345" in column B of the same row.
I'll need to change this frequently for the different category codes that need to be input and descriptions I need to search. I would do this in Access but the Administrator and the Assitant Administrator do not like Access. And because this is a large worksheet (and project), they are assisting in putting the proper category code with its associated description. Is there an easy way to do this in Excel? Maybe I should just ask what would be the best way to do this in Excel? :confused:

Thank you all in advance for any help you can provide!
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
make a lookup table

cleaning 12345
dusting 23456
polishing 44444

D1= cleaning in B1 =vlookup (D1, mytable,2)

lookup table must have column 1 in ascending order
 

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,313
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top