Split and vlookup

12 posts / 0 new
Last post
Ahmed
Offline
Joined: 09/20/2017 - 05:45
Split and vlookup

Dear All,
I'm looking for a formula or a script that help me to :
First, split the dial code (caracter value ) from 8 digit to 1 in the file A, Second; perform a VLOOKUP on the File B of these spliter fields.
Thanks.
Ahmed.
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Ahmed,

Any chance you can give an example of what you are trying to do.  Give a before and after picture would be great.

Thanks

Brian

Ahmed
Offline
Joined: 09/20/2017 - 05:45

Hi Brian,
Here's I attached you what I usualy do it in IDEA using a macro; so my goal is to make it more useful as possible by -for example- using a dialog box.
what do you think ?
Thank you.
Ahmed.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Ahmed,

Is there any chance you can supply some sample files.  Seeing the data would make it easier to understand the script.

Thanks

Brian

Ahmed
Offline
Joined: 09/20/2017 - 05:45

Hi Brian,
I read you post and I hope you're doing well.
here's the sample that I usually do it.
Thanks.
Ahmed

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Ahmed,

Yes I am doing better, I am back to work now and I am going for a follow-up with my doctor tomorrow so I think things are healing well.

Thanks for the files, it helps me understand what you are trying to do.  Let me see if I can come up with something.

Brian

Ahmed
Offline
Joined: 09/20/2017 - 05:45

Hi Brian,
Is there any new for my query ?
Thanks.
Ahmed.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Ahmed,

Try this one out.  It is your code but now you select the files and fields from a dialog.  Let me know if you have any problems.

Brian

Ahmed
Offline
Joined: 09/20/2017 - 05:45

Hi Brian,
I Try it over the same file that I shared with you as an example, but I got this error message,
Thank you
Ahmed
 

Images: 
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Sorry, change the "," in the equations to ";" and that should fixed the problem.

Ahmed
Offline
Joined: 09/20/2017 - 05:45

Thank you very much Brian.

Images: 

Pages