Forum Discussion
Solved
INDEX function help
I'm going to try to explain this well haha. In the image below, I want all POs (Column V) that have an "11" beside them (Column U) to be listed in Column X. The formula I'm using is below. In co...
If with old style that could be
=IFERROR( INDEX( $V$3:$V$21, AGGREGATE( 15,6, (ROW($U$3:$U$21)-ROW($V$2))/($U$3:$U$21=X$2), ROW()-ROW(X$2) ) ), "" )Please see attached.
If with old style that could be
=IFERROR(
INDEX( $V$3:$V$21,
AGGREGATE( 15,6,
(ROW($U$3:$U$21)-ROW($V$2))/($U$3:$U$21=X$2),
ROW()-ROW(X$2)
)
),
"" )Please see attached.
ColemanR2450 , you are welcome