My formula is not displaying the result. It seems like it is identifying the result, but not displaying it in the cell where this formula resides.
=IFERROR(INDEX($J1, MATCH(MIN(IF(ISNUMBER($D:$D), MATCH($D:$D, $D:$D, 0))), MATCH($D:$D, $D:$D, 0), 0)), "")
What its suppose to do:
Search column D.
This first time a value appears in column D, identify the number that appears in column J of the same row, and display it in column K of the same row where the formula is.
In column D, any instances where the value appears multiple times, it is only the first occurrence that should be displayed.
(this formula searches "numbers" in column D. Once I can get this to work, then i need one that searches through "text" in column D) and works the same way.
Thank you
=IFERROR(INDEX($J1, MATCH(MIN(IF(ISNUMBER($D:$D), MATCH($D:$D, $D:$D, 0))), MATCH($D:$D, $D:$D, 0), 0)), "")
What its suppose to do:
Search column D.
This first time a value appears in column D, identify the number that appears in column J of the same row, and display it in column K of the same row where the formula is.
In column D, any instances where the value appears multiple times, it is only the first occurrence that should be displayed.
(this formula searches "numbers" in column D. Once I can get this to work, then i need one that searches through "text" in column D) and works the same way.
Thank you