Info from worksheet to worksheet pulling from list

A

Alash25

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!
 
B

Bernard Liengme

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
 
L

Luke M

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