Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to MATCH a value out of a cell on an ARRAY - help pls
Hi all
I'm trying to figure out how I can return an index to an array of values using "MATCH". It should be a simple MATCH function but after digging through the questions & answers on "match" and trying using help for a couple of hours I gave up. I have an array, {"NONE","NEGLIGIBLE","MILD","MODERATE","HIGH","SEV ERE"} and want to match this array against the value out of a cell. Problem is the double-quotes, as far as I can tell. This function below works, =MATCH("HIGH",{"NONE","NEGLIGIBLE","MILD","MODERAT E","HIGH","SEVERE"},1) But these functions below always fail, the first is an attempt to use a literal value, the second is an attempt to use a value out of a cell =MATCH(CONCATENATE("""",HIGH,""""),{"NONE","NEGLIG IBLE","MILD","MODERATE","HIGH","SEVERE"},) MATCH(CONCATENATE("""",N13,""""),{"NONE","NEGLIGIB LE","MILD","MODERATE","HIGH","SEVERE"},) What am I doing wrong ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |