Excel - How to Use a VLOOKUP Formula - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.