Lookup and Name cells

[Guest]

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.

 

[Guest]

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

 

[Don Guillett]

One easy way>goto the suppliers sheet>highlight the range to name>type in a
name in the NAME box to the left of the formula box>touch the enter key.