Vlookup

D

datadummy

Active Member
Joined
Mar 16, 2017
Messages
312
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
Re: Help with VLOOKUP

It's because your lookup range is 1 column wide, but you are trying to return a value from the 7th column.
Try
$B$2:$I$186
 
Upvote 0
Re: Help with VLOOKUP

That did the trick! Is there anyway to drag the formula across the row and have it automatically change what column it is pulling from?
 
Upvote 0
Re: Help with VLOOKUP

Yup, where is the formula to start with & do you want to pull from col I to start with?
 
Upvote 0
Re: Help with VLOOKUP

My formula is in column L on my Demographics tab and I want it to pull from the Case_Form tab from column G or 6 for the purpose of the formula over.
 
Upvote 0
Re: Help with VLOOKUP

In that case try
=VLOOKUP($B15,Case_Form!$B$2:G$186,COLUMN()-6,FALSE)
 
Upvote 0
Re: Help with VLOOKUP

That worked for the next two columns but wouldn't pull anything passed that, any idea why it stopped after 2 columns?
 
Upvote 0
Re: Help with VLOOKUP

What did it return?
 
Upvote 0
Re: Help with VLOOKUP

After the first three columns came over the remainder returns #REF !
 
Upvote 0
Re: Help with VLOOKUP

In that case what is the formula that you are using?
 
Upvote 0
You must log in or register to reply here.

Similar threads

Allen_Mead
  • Solved
Textjoin / iferror and ifs
2
Replies
10
Views
442
Fluff
Fluff
F
  • Question
Multiple OR criteria in argument
Replies
2
Views
154
awoohaw
awoohaw
Cliffork
  • Solved
Conditional formatting formula help
Replies
6
Views
310
Peter_SSs
Peter_SSs
J
  • Solved
If(vlookup or formula
Replies
2
Views
151
Jon3sy
J
M
  • Question
VLOOKUP help - return value if two partial matches are met (I think??)
Replies
5
Views
279
MountainFog
M

Forum statistics

Threads
1,214,591
Messages
6,120,432
Members
448,961
Latest member
nzskater

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top