# Excel - COLUMN Function Problem - Expert Solution

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.

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.