sllaksvb
09-07-2017, 01:33 PM
Hi all,
s = Application.IfError(Application.Match(Sheets("GetCodes").Cells(i, 3), Sheets("Entities").Range("1:1"), True), 0)
I am trying to get my macro to return 0 if there isnt a match between my value in Sheets("GetCodes") and Sheets("Entities"). If there is a match, my macro will continue running. It seems to be working perfectly, however I have one cell in Sheet("GetCodes") that value is "UBB GE London Branch" and it does not match with the value "UBB" in Sheet("Entities"). How can I amend the above code so that "UBB GE London Branch" would be a match with "UBB" and not return a value of 0 when running this code?
Any help would be greatly appreciated! Thank you!
s = Application.IfError(Application.Match(Sheets("GetCodes").Cells(i, 3), Sheets("Entities").Range("1:1"), True), 0)
I am trying to get my macro to return 0 if there isnt a match between my value in Sheets("GetCodes") and Sheets("Entities"). If there is a match, my macro will continue running. It seems to be working perfectly, however I have one cell in Sheet("GetCodes") that value is "UBB GE London Branch" and it does not match with the value "UBB" in Sheet("Entities"). How can I amend the above code so that "UBB GE London Branch" would be a match with "UBB" and not return a value of 0 when running this code?
Any help would be greatly appreciated! Thank you!