Hi All,
I was hoping there would be a way to write a VBA script that is basically a vlookup but needs to be able to be case sensitive.
I have two sheets in my workbook. Sheet 1 has the Account ID and Sheet 2 has Account ID and Names (examples below). I would like to the VBA to look at Sheet 1's account numbers and find the corresponding Names in Sheet 2 to bring over. The catch is, as you can see, some of my account numbers are the same except for the capitalization, which is why i can't use a standard vlookup. Please let me know if someone could help me with writing this VBA. I have tried to use =LOOKUP(9.99999999999999E+307,FIND($D64,'Sheet2'!$A$3:$A$3009),'Sheet2'!$B$3:$B$3009) but when i update I always have random #N/As come up and I don't want to deal with going through them on a monthly basis to figure out why.
<tbody>
</tbody>
I was hoping there would be a way to write a VBA script that is basically a vlookup but needs to be able to be case sensitive.
I have two sheets in my workbook. Sheet 1 has the Account ID and Sheet 2 has Account ID and Names (examples below). I would like to the VBA to look at Sheet 1's account numbers and find the corresponding Names in Sheet 2 to bring over. The catch is, as you can see, some of my account numbers are the same except for the capitalization, which is why i can't use a standard vlookup. Please let me know if someone could help me with writing this VBA. I have tried to use =LOOKUP(9.99999999999999E+307,FIND($D64,'Sheet2'!$A$3:$A$3009),'Sheet2'!$B$3:$B$3009) but when i update I always have random #N/As come up and I don't want to deal with going through them on a monthly basis to figure out why.
Account ID | Account Name |
0013600000LeWaJ | Caroline |
0013600000LeWaj | Mike |
0013600000LeWaK | Pat |
0013600000LeWak | David |
0013600000LeWaL | Emily |
0013600000LeWal | Jeff |
0013600000LeWaM | Kevin |
0013600000LeWam | Greg |
0013600000LeWaN | Jennifer |
0013600000LeWan | Stephanie |
0013600000LeWaO | Brad |
0013600000LeWao Thank you in advance for your time! | Tony |
<tbody>
</tbody>