vlookup

RolanDoobies

Board Regular
Joined
Aug 28, 2002
Messages
99
Im trying to do a vlookup for to bring up several colums of data to the right of the referenced cell, but i cant get the column munber to change when i copy the cell to the next column. is this possible?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

RolanDoobies

Board Regular
Joined
Aug 28, 2002
Messages
99
PaddyD,
Thank you soooo much. that was quite painless.
I have another issue too, but ill post in the main forum.
 

RolanDoobies

Board Regular
Joined
Aug 28, 2002
Messages
99
Bummer,
No matter what I try now, it wont work. Im trying to put in 23 colums and i get a #na
what am i doing wrong?
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234

ADVERTISEMENT

#na doesn't mean you've got it wrong, it means there was not matching value. You can get round this if you want, but why bother - knowing that a value is not there is positive info, not an error (although post back if you do want to get rid of them)

Paddy
 

RolanDoobies

Board Regular
Joined
Aug 28, 2002
Messages
99
The value is there though.
It looks like the lookup cell changes when the column changes, so if i get a column with a zero in it, it jumps to the top row and starts entering that data.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234

ADVERTISEMENT

post your formula.
 

RolanDoobies

Board Regular
Joined
Aug 28, 2002
Messages
99
=VLOOKUP(B2162,B2141:Y2154,{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24},FALSE)
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
On 2002-08-29 19:32, RolanDoobies wrote:
=VLOOKUP(B2162,B2141:Y2154,{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24},FALSE)

First thought:

the table reference in your lookup is
B2141:Y2154. This is a relative reference. (The absolute reference would look like $b$2141:$y$2154). I assume that you wrote this formula in a cell higher up in the spreadsheet & copied it down. If so the relative references will have changed & the vlookup's probably not looking in the right place any more. Change te references to absolute before you copy the formula down, or use a named range.

Paddy
 

Forum statistics

Threads
1,148,528
Messages
5,747,221
Members
424,069
Latest member
kamkwok1hh

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
Top