Vlookup is failing to take different formats of ID in Excel from LO99 to LO100?
I am working on automating the calculation of Remaining amount by linking different pages with the ‘Loan ID’ by using this formula “=VLOOKUP(A3256, ‘Master Data Sheet’!$A$2:$E$100, 5, FALSE) – SUMIFS(C$2:C3256, A$2:A3256, A3256)” but its working for Loan Id LO99 , when it comes to LO100, its not . Kindly let me know what might be the reason