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.
Ahmed
Offline
Last seen: 3 years 6 months ago
Joined: 09/20/2017 - 05:45
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
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.
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
Hi Brian,
I read you post and I hope you're doing well.
here's the sample that I usually do it.
Thanks.
Ahmed
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
Hi Brian,
Is there any new for my query ?
Thanks.
Ahmed.
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
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
Sorry, change the "," in the equations to ";" and that should fixed the problem.
Thank you very much Brian.
Pages