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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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
103
Beh162
B
excelbytes
  • Solved
Looping Procedure In VBA Code
2 3
Replies
24
Views
421
excelbytes
excelbytes
A
  • Question Question
XLookup and IF formula
Replies
2
Views
67
RoryA
RoryA
L
  • Question Question
Automatically use the right tab in a vlookup
2
Replies
11
Views
112
dreid1011
dreid1011
N
  • Question Question
Vlookup with max formula
Replies
1
Views
352
Fluff
Fluff

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

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