**Question description:**

*This user has given permission to use the problem statement for this
blog.*

im trying to make a formula to where it will pull a value from a different sheet. i have tried looking up index and vlookup but i cant get them to work properly and not sure what i am doing wrong

Solved by O. J. in 23 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

User
25/03/2018 - 08:52

is someone there?

Excelchat Expert
25/03/2018 - 08:53

hi

Excelchat Expert
25/03/2018 - 08:53

do you have files to work on?

User
25/03/2018 - 08:55

trying to get it to where the value i put into b2

User
25/03/2018 - 08:55

will fill the c2 and d2 with stats from sheet 2

User
25/03/2018 - 08:56

so if i 1 put in b2 i would want c2 to show the value from sheet 2 A1

Excelchat Expert
25/03/2018 - 08:56

ok sheet2 is completed?

User
25/03/2018 - 08:56

ya

Excelchat Expert
25/03/2018 - 08:57

ok c2 will show A1 and d2?

User
25/03/2018 - 08:57

it would be the same for the stat column but if i get the formula for one i can do it to the others

User
25/03/2018 - 08:58

not worried about column d as it will use the same formula as column c

User
25/03/2018 - 08:58

with just different reference

Excelchat Expert
25/03/2018 - 08:59

check

User
25/03/2018 - 09:00

it works

User
25/03/2018 - 09:00

so i missed the match part then

Excelchat Expert
25/03/2018 - 09:01

ah yeah may be

User
25/03/2018 - 09:02

okay so how do i get it to show the numbers from d?

Excelchat Expert
25/03/2018 - 09:02

from col B?

Excelchat Expert
25/03/2018 - 09:02

of sheet 2?

User
25/03/2018 - 09:03

D2 should show numbers from column 2 of sheet 2

Excelchat Expert
25/03/2018 - 09:03

But based on which match? Matching col B of sheet 1?

Excelchat Expert
25/03/2018 - 09:04

just tell me what it should show now?

User
25/03/2018 - 09:05

the same thing as before D2 should look at B2 and get the number from Column B on sheet 2

Excelchat Expert
25/03/2018 - 09:05

but you can see there is no 5 in col B of sheet 2

User
25/03/2018 - 09:05

so the first one wasnt the right one

User
25/03/2018 - 09:05

i know but i want the number from b5 from sheet 2 to show up there

Excelchat Expert
25/03/2018 - 09:06

so you need 10 to show up?

User
25/03/2018 - 09:06

yes

User
25/03/2018 - 09:07

w/e the user puts in the B2 sheet 1 should pull from sheet 2 from that row on sheet

Excelchat Expert
25/03/2018 - 09:08

check

Excelchat Expert
25/03/2018 - 09:08

the formula is changed

User
25/03/2018 - 09:09

okay, that is different from what i remember few years ago when i was doing something similar but this works out fine and is simpler

User
25/03/2018 - 09:10

so just to make sure tho

Excelchat Expert
25/03/2018 - 09:10

I think so, for your requirement this should be the simplest most

User
25/03/2018 - 09:10

what does the indirect mean?

Excelchat Expert
25/03/2018 - 09:12

indirect function has the capability to refer another cells value using text and numeric values

Excelchat Expert
25/03/2018 - 09:12

you can see I have 3 inputs inside indirect

Excelchat Expert
25/03/2018 - 09:13

two of them are texts and one is the value(value of cell B2)

Excelchat Expert
25/03/2018 - 09:13

Indirect turns this 3 into one cell reference , which you can see Sheet2!A2....etc

Excelchat Expert
25/03/2018 - 09:14

so ok?

User
25/03/2018 - 09:14

i think i get it,

User
25/03/2018 - 09:14

i very much appreciate the help been browsing different help sites for an hour

Excelchat Expert
25/03/2018 - 09:14

just try and you can ask me if you face any difficulties

Excelchat Expert
25/03/2018 - 09:15

my pleasure, just in case if you leave please rate me after ending the chat from your end

User
25/03/2018 - 09:15

iwill def come back here in the future for more help and will probably need it >< just trying to make a guide for a game im playing

User
25/03/2018 - 09:15

i will

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*