LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 44
Default 'TABLE' array function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
array table and vlookup DV Excel Worksheet Functions 7 October 25th 07 04:09 PM
Variable Table Array in Lookup Function matt_the_brum Excel Worksheet Functions 6 August 4th 06 05:07 PM
Table array hapitaron Excel Discussion (Misc queries) 2 November 17th 05 03:40 PM
Looking up a value from an array table Kiser Excel Worksheet Functions 1 October 3rd 05 06:34 PM
How to use a cell value as Table Array in VLOOKUP worksheet function willydlish Excel Discussion (Misc queries) 2 February 16th 05 02:47 AM


All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"