vlookup-cell range in formula changes when copied to another cell
 

I've sent up several "forms" on one worksheet. When I copy the "master form"
under another, the cell range in the vlookup formula changes. I need the
cell range in the formula to remain the same no matter where it is copied in
the worksheet. Any suggestions?

example: =VLOOKUP(B39,'Other Crystals & Findings'!A1:B225,2)

I need it to always remain A1:B225.


Thanks,
Pixiemom

vlookup-cell range in formula changes when copied to another cell
 

Use absolute references like below
=VLOOKUP(B39,'Other Crystals & Findings'!$A$1:$B$225,2)

Even better
Create a NAME (eg Lookup_Table) for the range 'Other Crystals &
Findings'!$A$1:$B$225 and use that... like
=VLOOKUP(B39,Lookup_Table,2)

"pixiemom" wrote:

I've sent up several "forms" on one worksheet. When I copy the "master form"
under another, the cell range in the vlookup formula changes. I need the
cell range in the formula to remain the same no matter where it is copied in
the worksheet. Any suggestions?

example: =VLOOKUP(B39,'Other Crystals & Findings'!A1:B225,2)

I need it to always remain A1:B225.


Thanks,
Pixiemom

vlookup-cell range in formula changes when copied to another c
 

Thank you so much! I knew there was an answer out there somewhere.

Thanks,
Pixiemom


"Sheeloo" wrote:

Use absolute references like below
=VLOOKUP(B39,'Other Crystals & Findings'!$A$1:$B$225,2)

Even better
Create a NAME (eg Lookup_Table) for the range 'Other Crystals &
Findings'!$A$1:$B$225 and use that... like
=VLOOKUP(B39,Lookup_Table,2)

"pixiemom" wrote:

I've sent up several "forms" on one worksheet. When I copy the "master form"
under another, the cell range in the vlookup formula changes. I need the
cell range in the formula to remain the same no matter where it is copied in
the worksheet. Any suggestions?

example: =VLOOKUP(B39,'Other Crystals & Findings'!A1:B225,2)

I need it to always remain A1:B225.


Thanks,
Pixiemom