Dynamic hlookup from two tables

Dear everyone,

I hope to automate the links to final report from various working tables. Please see the table with explanation.

Grateful you could help me

Thank you very much.

Regards
Dewdrop

Hi Vikas,

Thanks for your idea, appreciate it. I've improved the table with other formula, after many round of trying.

Thanks again.