Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I have come across a spreadsheet with the following formula in it {=TABLE(J88,G88)} i know that this is some sort of array formula because of the {} brackets, however i cannot get this to work outside the file i have been sent. there is no Help about this in Excel & when i try to Ctrl+Shift+Enter into a new cell, looking up the same cell references, it fails to work, saying "This formula is not valid"? Is 'TABLE' a bespoke formula of some kind? Do i need some special Add-In enabled? I have both the Analysis Paks turned on? Any help gratfeully recieved, let me know if you need anymore info cheers jb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
array table and vlookup | Excel Worksheet Functions | |||
Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
Table array | Excel Discussion (Misc queries) | |||
Looking up a value from an array table | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) |