I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison
=match(round(a6,1),Sheet!A6:A1000)
I need
=match(round(a6,1,round(sheet!a6:a1000))
every syntax I use generates a error.
Can anyone help?
=match(round(a6,1),Sheet!A6:A1000)
I need
=match(round(a6,1,round(sheet!a6:a1000))
every syntax I use generates a error.
Can anyone help?