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

[infojacques]

Hi,

I made formulas that are working good. But I can not copy them easily.

Can anyone help me ?

My problem is detailed into the following Excel file http://cjoint.com/?hpv1YggtI1

Thanks for your support.

Jacques

 

[Guest]

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

 

[infojacques]

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