I am trying to use a named range for the table in HLOOKUP where the named range appears in another spreadsheet cell. I have tried entering the range in the HLOOKUP formula as the result of the CELL("contents') function but this does not work, any suggestions? The HLOOKUP function does work correctly if I enter manually the named range in the formula. I am wondering if HLOOKUP will only accept a range or range name and not a formula that retums that name from another cell, if this is so does anyone have any suggestions on how to achieve the table lookup a different way when the table range is a variable?
Thanks
Bookmarks