Using lookup in Excel?

M

mike m

I have a long spreadsheet download with 1 column
of "codes" which relates to the rest of the data. I found
the definitions for the codes, and have them on another
worksheet. Basically, I want to Find and Replace, but of
course I do not want to do it manually with the Find
Function. I'm not sure if I need to use an If/then
Logical function of the Lookup function, and lucky me, I'm
too rusty to remember exactly how to do it.
If someone can help, thank you very much.
MIKE
 
Top