Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP keeping array lookup reference
How do you maintain the cell references for the lookup table when copying the
function to additional cells? -- rebdk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP keeping array lookup reference
Use Absolute addressing as in
=VLOOKUP(F1,$A$1:$E$1,3,FALSE) F1 is relative and increments as you drag down the column. The table references do not change. Gord Dibben MS Excel MVP On Tue, 4 Jul 2006 11:59:01 -0700, rebdk wrote: How do you maintain the cell references for the lookup table when copying the function to additional cells? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP keeping array lookup reference
To do as Gord suggests, click on the A1 in the formula and then hit the F4
key until you get the desired absolute reference. F4 will toggle through the four reference choices. HTH Regards, Howard "rebdk" wrote in message ... How do you maintain the cell references for the lookup table when copying the function to additional cells? -- rebdk |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP keeping array lookup reference
Thanks so much. Problem solved.
-- rebdk "L. Howard Kittle" wrote: To do as Gord suggests, click on the A1 in the formula and then hit the F4 key until you get the desired absolute reference. F4 will toggle through the four reference choices. HTH Regards, Howard "rebdk" wrote in message ... How do you maintain the cell references for the lookup table when copying the function to additional cells? -- rebdk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I perform a lookup on an 80,000 line array? | Excel Worksheet Functions | |||
Reference different files using vlookup | Excel Worksheet Functions | |||
2 way Vlookup - Creating array arguments from columns | Excel Discussion (Misc queries) | |||
Array | Excel Worksheet Functions | |||
How do I return an entire row of data from a reference array? | Excel Worksheet Functions |