Hello,
I'm comparing 2 sets of data for accounts that are of the same value.
My V-Look Up is comparing column A in the 'Account Summary' tab with column D in the 'Tableau April' tab. The result is shown in column C in the 'Account Summary' tab.
My problem is one set of data may have ending zeros that the other set of data does not. For example on the "Account Summary" tab cell A3 has the value "4352.1" and cell D13 has the value "43521.100" this would be the same account.
Would it be possible to change the look-up formula to disregard the ending zeros if the numbers preceeding the zeros are match?
Any help on this would be greatly appreciated
Bookmarks