**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.*