Replacing ROW & COLUMN Function

[mchu1]

Hi Gurus,

I need help on modifying the following formula by replacing ROW() and COLUMN() with other Excel functions.

=INDEX($A$1:$E$12,SMALL(IF($K$14=$A$1:$E$12,ROW($A$1:$A$12)-MIN(ROW($A$1:$A$12))+1,""),ROW(A1)),COLUMN(A1))

I am not a savvy Excel user, so please help.

Regards,
Mary

[p24leclerc]

Can you tell us what is this formula doing?

[Whizbang]

It looks like a variation on this formula:
http://www.get-digital-help.com/2009...okup-in-excel/

This is returning multiple results from a lookup. It looks like it is returning results from multiple columns instead of just one, however.

Without more information, especially a sample workbook, I am not sure how much help can be given.

Row and Column are, in my opinion, the best way to handle this. Row(A1), Column(A1) will always return 1,1, no matter where this formula is entered. And fill this formula down and accross, it will automatically update to ({2,1},{3,1},{1,2},{2,2}...) and so on. I do not see why you would want to change this.