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.