Vlookup

D

datadummy

Active Member
Joined
Mar 16, 2017
Messages
313
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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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

B
  • Question Question
Vlookup formula across multiple tables #N/A when lookup not present
Replies
3
Views
118
Beh162
B
excelbytes
  • Solved
Looping Procedure In VBA Code
2 3
Replies
24
Views
455
excelbytes
excelbytes
A
  • Question Question
XLookup and IF formula
Replies
2
Views
99
RoryA
RoryA
L
  • Question Question
Automatically use the right tab in a vlookup
2
Replies
11
Views
128
dreid1011
dreid1011
W
  • Solved
Formula simplification request
Replies
4
Views
140
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,903
Messages
6,175,287
Members
452,631
Latest member
a_potato

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