Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) |