Forum Discussion
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.
Depending on which row the value is located in, I want it to return a number.
For example, if the number is in row 1, it returns 10, if the number is in row 2, it returns 20....
4 Replies
- 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.
=CHOOSE(AGGREGATE(15,6,ROW(A1:J3)/((A1:J3=E5)),1),1,10,20
Thank you. This worked. Not sure I understand it, but it works. Going to have to learn about choose and aggregate.
Hi,
=AGGREGATE(15,6,ROW(A1:J3)/((A1:J3=A6)),1)*10
