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
S Campbell's avatar
S Campbell
Copper Contributor
Feb 24, 2018
I don't think I explained well enough. Try again... Row 1, Values in cells a thru j Row 2, Values in cells a thru j Row 3, Values in cells a thru j I want formula to look at cell E5 and see if value in E5 is in any of those cells above. If it is in row 1, I want it to return the number 1. If it is in row 2, I want it to return the number 10. If it is in row 3, I want it to return the number 20.
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.