Hi,
I'd like some help with an array function that i found online.
I want the formula only to return the found match if cell in the L-column on the same row is equal to "Ombokas".
This is the array formula:
{=INDEX($C$3:$C$8, SMALL(IF(ISNUMBER(MATCH($B$3:$B$8, $E$3, 0)), MATCH(ROW($B$3:$B$8), ROW($B$3:$B$8)), ""), ROWS($A$1:A1)))}
I have attached a file that contains the problem.
In the context of the problem, I would only want the results 6, 4 and 1 to return if the cell in the L-column on each respective row where the data was gathered to be equal to "Ombokas". (the cell in LX should say "Ombokas")
In the same example only the 6 should return.
Thanks in advance!
Erik W
Bookmarks