Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to grab a value in column D on another spreadsheet where the corresponding value in the same row = a value found in row A on my spreadsheet
Solved by Z. F. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/04/2018 - 12:36
Hi there!
User
27/04/2018 - 12:36
Hello
Excelchat Expert
27/04/2018 - 12:36
I think you're right, the VLOOKUP should work nicely for this. Might you be able to share your file?
User
27/04/2018 - 12:37
can you see me adding data to the right?
Excelchat Expert
27/04/2018 - 12:37
Totally
Excelchat Expert
27/04/2018 - 12:37
It's perfect.
Excelchat Expert
27/04/2018 - 12:38
I will code the function you need!
User
27/04/2018 - 12:38
great thank you
User
27/04/2018 - 12:40
can you explain the functions
Excelchat Expert
27/04/2018 - 12:40
Totally - something odd is happening though
Excelchat Expert
27/04/2018 - 12:41
Any formula I code in this google sheet it doesn't display!
Excelchat Expert
27/04/2018 - 12:41
Check out cell C11
Excelchat Expert
27/04/2018 - 12:42
Weird eh?!
User
27/04/2018 - 12:42
mine is showing
User
27/04/2018 - 12:42
i see 4
Excelchat Expert
27/04/2018 - 12:42
This is so strange!
Excelchat Expert
27/04/2018 - 12:42
Well that is good...
Excelchat Expert
27/04/2018 - 12:42
Are the VLOOKUPS working?
User
27/04/2018 - 12:42
yes it looks like it thanks
Excelchat Expert
27/04/2018 - 12:42
do you see the right answers in column B?
Excelchat Expert
27/04/2018 - 12:43
so so strange. All I see are blank cells
Excelchat Expert
27/04/2018 - 12:43
Anyhow - I can explain the logic for you for sure
Excelchat Expert
27/04/2018 - 12:43
So the A2 part is the value that is being looked up
Excelchat Expert
27/04/2018 - 12:43
The D2:F8 is the range or data table that it is looking in
Excelchat Expert
27/04/2018 - 12:44
and the 2 is the # of columns over to bring back the value
User
27/04/2018 - 12:44
what about now there is a gap between d and f
Excelchat Expert
27/04/2018 - 12:44
So now you would just change the 2 to a 3
User
27/04/2018 - 12:44
ah ok
Excelchat Expert
27/04/2018 - 12:44
Did it work? ( I can't see it haha)
User
27/04/2018 - 12:44
yes worked fine
Excelchat Expert
27/04/2018 - 12:44
Amazing
User
27/04/2018 - 12:44
how would i grab the data range from another spreadsheet
User
27/04/2018 - 12:45
=VLOOKUP(A3,D3:F9,2,0)
Excelchat Expert
27/04/2018 - 12:45
Is the spreadsheet in the same workbook?
User
27/04/2018 - 12:45
no
Excelchat Expert
27/04/2018 - 12:45
are you able to copy the other sheet into your main sheet in another tab?
Excelchat Expert
27/04/2018 - 12:46
The dollar signs are key as well
Excelchat Expert
27/04/2018 - 12:46
=VLOOKUP(A7,$D$2:$F$8,3,0)
User
27/04/2018 - 12:46
i think ive done it anyway actually
Excelchat Expert
27/04/2018 - 12:46
those keep the data range static
Excelchat Expert
27/04/2018 - 12:46
Oh amazing... do you have everything you need?
User
27/04/2018 - 12:48
i think so
User
27/04/2018 - 12:48
what is the final number again
User
27/04/2018 - 12:49
2 is columns over
User
27/04/2018 - 12:49
0 is?
Excelchat Expert
27/04/2018 - 12:49
This is the technical reasoning for that 0 - Indicates whether the column to be searched (the first column of the specified range) is sorted, in which case the closest match for search_key will be returned.
Excelchat Expert
27/04/2018 - 12:50
So 0 makes it find the EXACT match
Excelchat Expert
27/04/2018 - 12:50
1 would find the closest match
User
27/04/2018 - 12:50
ok great
User
27/04/2018 - 12:51
i think that's it
User
27/04/2018 - 12:51
thanks very much for your help
Excelchat Expert
27/04/2018 - 12:51
Please ping us back if you need further assistance and we will be happy to help!
Excelchat Expert
27/04/2018 - 12:51
My pleasure have a great day ~
User
27/04/2018 - 12:51
great, thank you
User
27/04/2018 - 12:51
you too
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.