| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and Auto Fill problesm
How can I get the look-up values to as auto fill
and leave the table array figures alone "Fix" the table array range with the dollar signs ($), ie make it absolute =VLOOKUP(a1,$a$1:$b$6,2) Then it won't change when you copy/fill down -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROBLESM IN COPYING BETWEEN WORKBOOKS AFTER EXCEL 2003 UPGRADE | Excel Discussion (Misc queries) | |||
| VLOOKUP / Auto Fill / IF? | Excel Discussion (Misc queries) | |||
| auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| using auto fill edit or fill handel | Excel Worksheet Functions | |||
Threaded Mode
