gloriag
02-24-2014, 11:37 PM
I am a newbie on VBA. I have a table as below (see also the attachment) and need to do the vlookup with "dept" if the left 2 characters of "EE Code" between 91 and 95. Is it possible to have a macro/VBA to complete the task?
EE Code
dept
How to generate from VBA Macro
9216000
12345678
vlookup arrary
A123456
23456700
39914123
test
7856370
39914123
38214125
test
9155800
57889056
40964197
test
9326600
38214125
77014155
test
9135800
39914123
3456999
40964197
9458000
77014155
9537903
00123432
9158000
12345678
0456999
57889056
5856370
39914123
EE Code
dept
How to generate from VBA Macro
9216000
12345678
vlookup arrary
A123456
23456700
39914123
test
7856370
39914123
38214125
test
9155800
57889056
40964197
test
9326600
38214125
77014155
test
9135800
39914123
3456999
40964197
9458000
77014155
9537903
00123432
9158000
12345678
0456999
57889056
5856370
39914123