Forum Discussion
Excel sorting cells with formula
Hi I got a question about Excel sorting. The function I used is Sort & Filter. Here is my setting - see below illustration: Column A - parameter input Column B-C - INDEX and MATCH function to ret...
IngeborgHawighorst Here's a sample document. I use $ sign for columns but not for rows because I have hundreds sets of data. If I used $ sign, I need to revise the formula in every row, right?
Thanks!
In your List sheet remove reference on this sheet in formulas, i.e. use
=INDEX(Update!D:D, MATCH($C5, Update!$C:$C,0))instead of
=INDEX(Update!D:D, MATCH(List!$C5, Update!$C:$C,0))
kittysum , you are welcome