Full Spool
New Member
 Joined
 Dec 31, 2012
 Messages
 22
 Office Version

 365
 Platform

 Windows
Hello,
I am having issues comparing 2 rows with vlookup. My issue is some of my numbers have a "5" after a series of numbers. Vlookup thinks the numbers
don't exist in my reference data. I don't know how to fix my formula to ignore the "5" and look at the numbers before so it can draw
a correct comparison.
My formula below "
=VLOOKUP(D2,Mapping!$A$2:$A$61,1,FALSE)
You can see when the 5 is in the Billing Tab and on the Mapping Tab in excel it works. However once the 5 is missing in the billing tab
it no longer correlates.
Thanks in advance for any help or direction provided.
I am having issues comparing 2 rows with vlookup. My issue is some of my numbers have a "5" after a series of numbers. Vlookup thinks the numbers
don't exist in my reference data. I don't know how to fix my formula to ignore the "5" and look at the numbers before so it can draw
a correct comparison.
My formula below "
=VLOOKUP(D2,Mapping!$A$2:$A$61,1,FALSE)
You can see when the 5 is in the Billing Tab and on the Mapping Tab in excel it works. However once the 5 is missing in the billing tab
it no longer correlates.
Thanks in advance for any help or direction provided.