| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Match Array returning #NA, Works individually
I'm having trouble with a Match array function. They work when I separate them into their own match function, but not when I try to do an array. I'm trying to lookup two values in different columns and return the corresponding row number.
This is my function: Code:
{MATCH(1,(('[OtherWB]Sheet1'!$B:$B=A3&"*") * ('[OtherWB]Sheet1'!$C:$C="*"&RIGHT($A$4,3)&"*")),0)}
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
| Match returning #N/A | Excel Worksheet Functions | |||
| Returning an array from a multi-dimensional array | Excel Programming | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match font color works ... but | Excel Programming | |||
Threaded Mode
