Using If and Vlook function with VBA

Hi,

Is is possible to achieve it by having macro.

statement :
If any cell in Column A match any cell in column G then corresponding cells in column B will be equal to corresponding cells in column H??

Please Login or Register  to view this content.

Many help please
regards

Try

Formula:

Please Login or Register  to view this content.

Hi Zbor,
Great work. I have clicked * to thank you.

However instead of filling up formule , can we have macro which will do the needful.
Just a thought
Regards

With this I can apply this to the whole sheet where corresponding cells in any column will have the same effect.

A B C D E F

Can you upload example of what you trying to do?

Hi
Apology for a late reply as I was away on work.
I have attached the sample file.
Many thanks for your help
Regards

Right click on sheet name -> View Code
Then paste this code:

Please Login or Register  to view this content.

If you want to change value within a same cell use:

Please Login or Register  to view this content.

Hi
Thanks a lot . I am currently having issues with my excel and the PC.
I will resolve and then check your solution.
Then will get back to you.
I really appreciate your help and I am sure it will work.
Thanks Pal
Regards

Hi
I have tried the codes and every time in try them the excel stops working.
I uninstalled MS office and reinstalled it with all MS updates. It still is not working .
It does not happen with other excel files and any of other change events.
I think we need to look at the code carefully and redefine it if possible
Sorry
regards

Hi
There something in this code which closes excel or stalls it.
I have tried to use it and hence I have decided not to proceed further on this for now.
Thanks any way.
regards