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
|