::: How to change formulas so I can copy them ? :::

  • Thread starter Thread starter infojacques
  • Start date Start date
Try these formulas:
C7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,6,FALSE)
D7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,5,FALSE)
E7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,3,FALSE)

The dollar signs ($) "Lock" that part of the reference so it won't change
when copied and pasted to another location.

Another alternative would be to create a Range Name for DataBase!$C$6:$EA$11.
Here's how:
Select DataBase!$C$6:$EA$11
Then....in the Name Box (the empty box just above the Col_A heading)
...Type: rngDatabase....then press [Enter]

Now your formulas can look like this:
C7: =HLOOKUP("ACTION TIME",rngDatabase,6,FALSE)
D7: =HLOOKUP("ACTION TIME",rngDatabase,5,FALSE)
E7: =HLOOKUP("ACTION TIME",rngDatabase,3,FALSE)

Named ranges don't need dollar signs to lock them in.

If you need to change the referenced area of rngDatabase....
From the Excel Menu: <insert><name><define>
....Locate rngDatabase....then change the references.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Hello,
Thank you for your answer.
I will try it all but hey, it looks great.
Many thanks for your support
Have a great day.
Jacques
 
Back
Top