Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Auto fill problem
=VLOOKUP(D6,Sheet2!E10:E11K28664,2)
How can I make this formula absoult. So I can copy down the column. I have tried several way witht $ but I cant figure it out please advsei |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Auto fill problem
You seem to have messed up two systems of cell references: A1 and R1C1.
Define a name for your table (InsertNameDefine) and use that in your formula -- Kind regards, Niek Otten Microsoft MVP - Excel "Dylan @ UAFC" wrote in message ... =VLOOKUP(D6,Sheet2!E10:E11K28664,2) How can I make this formula absoult. So I can copy down the column. I have tried several way witht $ but I cant figure it out please advsei |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Auto fill problem
1. First, you need to fix the formula. E11K28664 is not a proper cell
address. You probably want: =VLOOKUP(D6,Sheet2!E10:K28664,2) 2. To make the table address absolute, use: =VLOOKUP(D6,Sheet2!$E$10:$K$28664,2) 3. To copy down, drag the fill handle (the small black box on the bottom right of the highlighted cell) down. 4. When you omit the fourth parameter of Vlookup, it assumes you want an approximate match (ie, your table is sorted in ascending order). If you want an exact match, use: =VLOOKUP(D6,Sheet2!$E$10:$K$28664,2,false) Regards, Fred. "Dylan @ UAFC" wrote in message ... =VLOOKUP(D6,Sheet2!E10:E11K28664,2) How can I make this formula absoult. So I can copy down the column. I have tried several way witht $ but I cant figure it out please advsei |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and Auto Fill problesm | Excel Worksheet Functions | |||
VLOOKUP / Auto Fill / IF? | Excel Discussion (Misc queries) | |||
Auto Fill Problem | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
using auto fill edit or fill handel | Excel Worksheet Functions |