Look Up with variable values

[leebird]

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

[FDibbins]

...My problem is one set of data may have ending zeros that the other set of data does not....

No, your problem is that Summary Acc No contains (mostly) values, but Month Acc No contains text - they are not the same.

Try this...
=IFERROR(VLOOKUP(A3&"*",'Tableau April'!D:P,13,FALSE),"Not Found")