Hi,
I find a formula perfect for my calculation, but I want to extend the range to 64001 rows instead of 8 that is in the forumla now
Can anyone see it and try to modify it to work with 64001 rows instead of 8, I tried to just replace the value but I canīt see how the formula works fully..
Formula:
=IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(1:1)),2)),"",INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(1:1)),2))
What I want is to look for a specific value in column A, pick the value in column B and return B as a seperate list.
Example:
Animal Name Lookup: 2
1 A Matches: B
2 B C
2 C G
2 G
7 F
7 D
9 B
Bookmarks