Try looking up the LOOKUP and/or VLOOKUP functions in Excel's help file. I
believe they are what you are looking for.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Alash25" wrote:

What I am trying to accomplish is on worksheet 1 - if I type a specific
number in a specifed column, then it can pull the info from worksheet 2 as to
the description of that number and place it in to the adjacent column on
worksheet 1. I attempted the IF, THEN function with no success. Plese help!