Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup function does not work when range is hidden
I created a vlookup function and it works when the range is not hidden. When
I hide the range, the vlookup function does not work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup function does not work when range is hidden
What is "does not work"?
Error message? Incorrect result? Nothing? Which range is hidden? The VLOOKUP table range? Is the lookup value cell not hidden? Is the VLOOKUP formula cell not hidden? Hiding the table should not create a problem. Hiding the table is a common practice. Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 09:48:02 -0700, VLOOKUP FUNCTION <VLOOKUP wrote: I created a vlookup function and it works when the range is not hidden. When I hide the range, the vlookup function does not work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Using text for the range in AVERAGE function | Excel Worksheet Functions | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions |