Macro for row wise lookup from Master Table

[kumarrajesh]

Hi All,

Thanks in Advance for your time to look into this.

I have Table 1, in which I want Status & Code to be retrieved from Master Table using ISIN & Sedol & CUSIP. The tricky part here is in Master Table we have only one identifier ISIN or Sedol or CUSIP.

We have to search with all identifiers from Table 1 in Master Table probably row wise, as we don't know with what identifier its there in Master Table.

Need a macro, when I run want the columns of Status & Code to be filled automatically in Table 1.

 

[Somendra Misra]

Hi Rajesh,

See the file for formula solution, if your file become slow in the actual file than write back, we can make macro for this.

If you still need macro than also write back, will try to make one for you.

Regards,

 

[kumarrajesh]

Hi Somendra,

Thanks much for your formula, its working but need a macro as my Master table consists around 1 lakh rows and its variable even my Table 1 data is variable. Here is my excel even I have written logic in the sheet, could you please help me with code.

Really thanks for your help.

 

[Somendra Misra]

Hi Somendra,

Thanks much for your formula, its working but need a macro as my Master table consists around 1 lakh rows and its variable even my Table 1 data is variable. Here is my excel even I have written logic in the sheet, could you please help me with code.

Really thanks for your help.

See this file.

Regards,

 

[kumarrajesh]

Hi Somendra,

Working perfectly,really great work.
Thanks again for the help and your time.

This forum is really helpful.

 

[Somendra Misra]

You are Welcome!!!

Regards,