Macro to find and add ISIN for a company based on stock codes

[itshewe]

Hi guys,

I have trying for 2 days now to write a macro/VBA that looks up IF the stock codes (i.e., in column A and G) match THEN insert the ID_ISIN from column H in the empty ISIN column C.

or should i use Vlookup?

Could you please help me guys.

If you need any further information please let me know!

best wishes

Hewe

[jewelsharma]

See attached. ISIN2.xlsx
Hope this is what you wanted.

[BS Singh]

Hi,

If I understood you correctly then you would like to fetch the corresponding value of stock Id from colum H to coldumn C..if so use vlookup as below at celll C2 and fill down to fetch the corresponding value of stock code:

=VLOOKUP(A2,$G$2:$H$1743,2)

let me if you want to fetch only if A2 matches with G2 and so on..

Regards,

[BS Singh]

Hi,

If I understood you correctly then you would like to fetch the corresponding value of stock Id from column H to column C..if so use vlookup as below at cell C2 and fill down to fetch the corresponding value of stock code:

=VLOOKUP(A2,$G$2:$H$1743,2)

let me if you want to fetch only if A2 matches with G2 and so on..

Regards,