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.
