Index Site ID in table 1 and match with table 2 array and return respective row value from table 2

[Asfandyar Ali]

Respected experts,
I need help to match 2 tables and return respective row value from 2nd table. Please see attached worksheet which explains the problem.

Thanks for your help.

Ali

 

[Somendra Misra]

Hi Ali,

See this file.

Regards,

 

[Asfandyar Ali]

Hello Somendra Ninja,
Thank you very much for the quick solution. It seems it will work, i will try it with my original data and get back to you in case i need further help.

Awesome dear. Thanks again.