Vlookup Basic Question

[jrwrita]

Hi,
I got two spreadsheets.

Example Sheet 1, have a bunch of columns:

ID , 1, 2, 3
1
2
3


Example Sheet 2:

ID, 1, 2, 3, Info, Info, Info
1
1.5
2
3
3.5

My question is, I need the data from "Info" columns from sheet 2 to be put into the next column for spreadsheet one for each ID.

Some Ids that exist in one, don't necessarily exist in two. So I need the values from "Info" in Sheet 2, to correspond with the proper ID's in Sheet 1 or atleast show an NA.

Right now I have =Vlookup(ID from sheet1, Entire Sheet 2 locked in with F4, Column 5, False), I'm doing something wrong.

Any help would be greatly appreciated. Thanks.

 

[elmer007]

Are your ID columns in column A?

Also, for troubleshooting purposes, could you paste the actual formula into the thread (instead of the paraphrased one in the question)? Just in case there is some kind of quirk or typo in it.

 

[jrwrita]

Are your ID columns in column A?

Also, for troubleshooting purposes, could you paste the actual formula into the thread (instead of the paraphrased one in the question)? Just in case there is some kind of quirk or typo in it.

My ID columns in in B actually.

And yes here it is:
=VLOOKUP(B2,Sheet1!$A$2:$S$47,13,FALSE)

So im looking up Value B2, in my other sheet. And I want to return the value in column 13 that correspondes with B2 (from the other sheet),

 

[elmer007]

The range that your formula looks to for data ("Sheet1!$A$2:$S$47") needs to have the IDs in the first column. So if on Sheet1 your IDs are in column B, then the formula should have the range $B$2:$S$47 instead. Also, if this fixes the formula, then you'll also need to change the "13" to "12" since this number is the number of columns over within the range (so column B would be column 1 in the formula, column C would be 2, etc.).

 

[SpillerBD]

also, if the Lookup value is a number or a number stored as text, the data where it is being looked up in must be the same type of data. "1" does not equal 1

 

[jrwrita]

The range that your formula looks to for data ("Sheet1!$A$2:$S$47") needs to have the IDs in the first column. So if on Sheet1 your IDs are in column B, then the formula should have the range $B$2:$S$47 instead. Also, if this fixes the formula, then you'll also need to change the "13" to "12" since this number is the number of columns over within the range (so column B would be column 1 in the formula, column C would be 2, etc.).

Great thanks! you the best!