Vlookup

[datadummy]

I have the following VLOOKUP formula that is returning #REF and am not sure why.

=VLOOKUP($B15,Case_Form!$B$2:$B$186,7,FALSE)

For reference the number in B15 is present on the Case_Form tab.

 

[datadummy]

Re: Help with VLOOKUP

=VLOOKUP($B15,Case_Form!$B$2:$I186,COLUMN()-6,FALSE)

 

[Fluff]

Re: Help with VLOOKUP

Ok, it should be
=VLOOKUP($B15,Case_Form!$B$2:I$186,COLUMN()-6,FALSE)

 

[datadummy]

Re: Help with VLOOKUP

That worked, thanks! So now I'm trying to make the formula work onto the other tab now and I'm clearly botching the formula again as I keep getting #REF ! as the response. Here is my formula,
VLOOKUP($B7,Demographics!$A$2:K$156,COLUMN()-4,FALSE)

 

[Fluff]

Re: Help with VLOOKUP

What cell is the formula in & what is the first column to be returned?

 

[datadummy]

Re: Help with VLOOKUP

The formula is in cell AH7 and the first column to be returned from the Demographics tab is column E.

 

[Fluff]

Re: Help with VLOOKUP

In that case use
VLOOKUP($B7,Demographics!$A$2:E$156,COLUMN(E7),FALSE)

 

[datadummy]

Re: Help with VLOOKUP

So in the event that my matching common number is not in the same row on each tab then how would I address that? For example my formula is in AH7 and the number in B7 on that tab but is in cell B15 on my reference tab "Demographics".

 

[Fluff]

Re: Help with VLOOKUP

Not sure I understand what you're saying.
Do you want to search col B of Demographics for the value in B7 rather than col A?

 

[datadummy]

Here is my current formula =VLOOKUP($B7,Demographics!$A$2:E$156,COLUMN(E7),FALSE)

What I would like to accomplish is take the number that is in B7 and locate it on the Demographics tab within the given range then return everything else in that row from column G over. I hope that makes sense.

 

[Fluff]

Earlier you said you wanted to get the values from column E onwards, now you're saying col G.
Which is it?