How do I copy a formula in excel where part remains absolute the .
=VLOOKUP(A2,Sheet2!A1:B664, 2, FALSE). I want the A2 to change when I go to
the next cell but I need the Lookup range in sheet 2 (A1:B664) to reamin the same. Thanks |
Putting dollar signs around the lookup range:
Sheet2!$A$1:$B$664 will make it absolute (locked) So, assuming the lookup values are listed in A2 down you could put in say, B2: =VLOOKUP(A2,Sheet2!$A$1:$B$664, 2, FALSE). and just copy B2 down -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- SRF wrote in message ... =VLOOKUP(A2,Sheet2!A1:B664, 2, FALSE). I want the A2 to change when I go to the next cell but I need the Lookup range in sheet 2 (A1:B664) to reamin the same. Thanks |
All times are GMT +1. The time now is 08:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com