Forum Discussion

S Campbell's avatar
S Campbell
Copper Contributor
Feb 24, 2018

EXCEL Formula

Stumped again...   I have three rows with 10 cells in each row with numbers in them.   I want formula to look at one cell (not in these rows) and see which row that same number is.   Depe...
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Feb 24, 2018
=CHOOSE(AGGREGATE(15,6,ROW(A1:J3)/((A1:J3=E5)),1),1,10,20
S Campbell's avatar
S Campbell
Copper Contributor
Feb 25, 2018

Thank you.  This worked.  Not sure I understand it, but it works.  Going to have to learn about choose and aggregate.