1- Table1 contains: Component
2- table2 contains : Component - Related Participant
Can I create a function that takeS the component in the first table to look for it in the second one in order to find the related participant ? Note that I can't create relationship between these two tables.
You can use VLOOKUP to get 2nd table component related participant without creating any function or relation. I just come up with below example for your reference.
A B C D
sno name sno name
2 mike 1 john
In above example I have given below formula in B2 cell
I am looking for Sno 2 name from my other table (c2:d4). Sno 2 should exists in other table to get corresponding value. You can get more help from Excel itself. Please let me know if you are looking something else. Unfortunately I am not able attach this sample excel file for you. If you are having trouble please suggest alternative how I can share this file with you.
Note: I am sorry for delayed reply, suffering from fever.