Vlookup-copying formula down whole column

Dabulughod

New Member
Joined
Apr 14, 2002
Messages
3
I set up my vlookup table and it reports back to the cell the proper reference. But when I copy the vlookup statement down the rest of the spreadsheet column, it displaces the vlookup table, one cell downward each time. How can I hold the table reference steady, while I do down my column? (Does that make any sense?). Thanks.
D
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Hiya,

Use Non-Relative references

Instead of =Vlookup(A2,X2:Y200,2,false) use
=Vlookup(A2,$X$2:$Y$200,2,false)

Adam
 
Upvote 0
On 2002-04-15 13:32, Dabulughod wrote:
I set up my vlookup table and it reports back to the cell the proper reference. But when I copy the vlookup statement down the rest of the spreadsheet column, it displaces the vlookup table, one cell downward each time. How can I hold the table reference steady, while I do down my column? (Does that make any sense?). Thanks.
D

Just freeze the range that houses your table with a few $$ like in:

=VLOOKUP(A1,$E$2:$G$20,2)
 
Upvote 0
On 2002-04-15 13:32, Dabulughod wrote:
I set up my vlookup table and it reports back to the cell the proper reference. But when I copy the vlookup statement down the rest of the spreadsheet column, it displaces the vlookup table, one cell downward each time. How can I hold the table reference steady, while I do down my column? (Does that make any sense?). Thanks.
D
Try using the locked cell reference e.g.
=VLOOKUP(H7,$I$7:$J$9,2,FALSE)
instead of the ordinary
=VLOOKUP(H7,I7:J9,2,FALSE)
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

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