Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to retrieve array name
i have a spread sheet with array names in each cell
I have a working formula to retrieve the correct array name The question =VLOOKUP(U51,MFFC!$A$2:$M$11,2) U51 is the cell for an age group (17) the spread sheet MFFC has the age groups starting the row and the cells contain array names. curlup pushups run swim bike eliptical 17 curlpt17 curltl17 pupt17 putl17 runpt17 runtl17 swimpt17 swimtl17 bikept17 biketl17 elippt17 eliptl17 the problem is that once retrieved, i cannot get the function to use the array name because it is deemed as just text and not recognized as a valid array name. this is the last step to automate my form and it is proving formidable. my only other alternative is to cut and paste the formula from another matching cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to use the lookup function to retrieve objects? | Excel Discussion (Misc queries) | |||
Is there a function/formula to retrieve the weeknumber? | Excel Worksheet Functions | |||
function to retrieve a list of unique characters from a column | Excel Worksheet Functions | |||
Worksheet function to retrieve cell value based on row an col numb | Excel Discussion (Misc queries) | |||
Can I retrieve a value and its format using the minimum function? | Excel Worksheet Functions |