Greetings,
Even though it feels like an easy problem, I didn't manage to get an elegant solution for it.

I have:
A named range Table1=O3:AG15
A List of Names as a named range List1= J31:J60 (Text Data)

A Name(From List1) may appear in any cell within Table1 using some VBA code.
I was trying to make a function that looks up each Name from List1 against the Table1 and if it exists to return the Row number at AY31:AY60 and the Column Number at AZ31:AZ60, else to return 0

Any help would be appreciated and thank you in advance.-