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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
141
Beh162
B
excelbytes
  • Solved
Looping Procedure In VBA Code
2 3
Replies
24
Views
478
excelbytes
excelbytes
A
  • Question Question
XLookup and IF formula
Replies
2
Views
128
RoryA
RoryA
L
  • Question Question
Automatically use the right tab in a vlookup
2
Replies
11
Views
148
dreid1011
dreid1011
L
  • Solved
YoY Increase over n Years - Sum all Years in a single formula
Replies
6
Views
67
Cubist
Cubist

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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