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!

Let's say Sheet2 has, starting in A1
1 Apples
2 Pears
3 Oranges
....
100 Quince

In C1 of Sheet1 you type 3
In D1 the formula =INDEX(Sheet2!B1:B100,C1) will return Oranges

But what if the numbers are not consecutive
11 Apples
23 Pears
45 Oranges
....
105 Quince

Then we need =VLOOKUP(C1,Sheet2!A1:B12,2,FALSE)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Alash25" wrote in message
...
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!

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!