Lookup and Name cells
 

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.

Lookup and Name cells
 

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.

Lookup and Name cells
 

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.