LinkBack URL
About LinkBacks
my guess is the your CONCENATE is creating a STRING not a NUMBER.....So, when you Lookup and compare the Co & acct combo they don't match...
you can add a * 1 to the end of the CONCATENATE and that forces XL to make it a number
my guess is the your CONCENATE is creating a STRING not a NUMBER.....So, when you Lookup and compare the Co & acct combo they don't match...
you can add a * 1 to the end of the CONCATENATE and that forces XL to make it a number
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks