Hi Lenni,

Select range D5:E8

In xl2007 version:
Select Formula Ribbon-Define name

In pre xl2007 versions:
Select menu item Insert-Name-Define

Insert a name of your choice say TestOne then OK

Select range E5:E8 and repeat above with another name say TextTwo

Edit the formula to replace ranges with names. Should look like this:-

=LOOKUP(C22,TestOne,TestTwo*'Summary '!C22)

Regards,

OssieMac




"lenni" wrote:

I need help.

I want my formulas to have name cell but not sure how to do this.

The formula is:
=LOOKUP(C22,Suppliers!$D$5:$E$8,Suppliers!$E$5:$E$ 8*'Summary '!C22)

and I want $D$5, $E$8, $E$5 & $E$8 to have name cell?

I tried to change but using the "Name Command"

However it still not working.

Can anyone please help.