I need to use an index - match formula in my excel sheet.
=INDEX(B:B,MATCH(I2,G:G,0))
I can pass the formula in within the add row excel connector, but the Row Number does not increment, it stays as I2 for all rows.
I tried switching to RC notation, but it did not appear to persist in excel online.
My flow first deletes all rows and then inserts new rows, so the formula needs to be inserted via the flow.
Is there a way to reference the current cell within the Match function that will increment properly?
Thanks!
Hi @GKS ,
You could use add() function to set the Row number.
Use variables to get all the Row numbers, then configure max() function to get the maximum value.
After pulsing 1 to the maximum value, add Row Number of the new row.
Best Regards,
Thanks that sounds like it would work.
I was able to solve this by reconfiguring my formula to not rely on relative cell references, so I replaced I2 in
=INDEX(B:B,MATCH(I2,G:G,0))
with
INDEX(I:I,ROW()),G:G,0)
Making the final formula
=INDEX(B:B,MATCH(INDEX(I:I,ROW()),G:G,0))
So it references the correct cell using INDEX and ROW instead of a relative cell reference, which does not increment without a lot of customization.
Hi @GKS ,
Great! In fact, using Excel formula in Flow is difficult to achieve its effect.
Best Regards,
User | Count |
---|---|
94 | |
46 | |
21 | |
19 | |
18 |
User | Count |
---|---|
137 | |
54 | |
42 | |
41 | |
30 |