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.

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.

One easy waygoto the suppliers sheethighlight the range to nametype in a
name in the NAME box to the left of the formula boxtouch the enter key.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"lenni" wrote in message
...
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.