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 |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com