LOOKUP and Name Cell

[lv2nok]

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.

[davesexcel]

Hi,
are you referring to named ranges in a lookup formula,
maybe attach a zipped example of your workbook, so others can see what you are referring to.