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.