Sorry, not sure if I put this question in the right place?? So just in case here it is again...thanks in advance.
Haha, minimums hey! I got another tag on question please.
The information in A column has to be trimmed to get rid of some extra values that comes from the data feed. The system adds to 2 #'s to a phone #, ie 419996665555, and I trim it using RIGHT(A1, LEN(A1)-2), so the result is 9996665555 which matches to the same # in column D. However once trimmed your formula that works great with straight text or numbers, doesn't work once the # is trimmed.
I have tried to copy and pasted VALUES only into another cell but I think the formatting has to match, and I cannot make that match. Otherwise using the cell that has the trimmed #, I get the error stating, "A value is not available to the formula or function'. Please help, I am so close I THINK?