Full Spool
New Member
- Joined
- Dec 31, 2012
- Messages
- 25
- 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.