D
daniel chen
I need help with a formula that will return the least column No.
when the contents of an array in the same row match
the contents of a lookup cell.
e.g. the lookup cell is Cell(J1) with content 3
Range("A3:H3") has array value : (4, 3, 9, 3, 3, 5, 7, 8)
Cell(J3) looks up Cell(J1) and find B3, D3 & E3 that match.
2, 4 & 5 are the column Nos of B3, D3 & E3 respectively.
Therefore Cell(G3) should returns 2 (the least value among 2, 4 & 5)
Appreciated!
when the contents of an array in the same row match
the contents of a lookup cell.
e.g. the lookup cell is Cell(J1) with content 3
Range("A3:H3") has array value : (4, 3, 9, 3, 3, 5, 7, 8)
Cell(J3) looks up Cell(J1) and find B3, D3 & E3 that match.
2, 4 & 5 are the column Nos of B3, D3 & E3 respectively.
Therefore Cell(G3) should returns 2 (the least value among 2, 4 & 5)
Appreciated!