Lookup cell value in an array or table

Hi ...

I've got this worksheet. Se attached file.

I want to lookup a certain row in column Names, and a certain column in first row.

Let's say I want the data of two persons, Moore vs Smith.

The cell where these two ranges meet is B56.

How can I get the value from the table where these two series meet? In this case B56

I've tried a number of solutions mostly using XLOOKUP() with two creiteria, but in vain.

Any tips?

How about

Formula:

Please Login or Register  to view this content.

Yeah! How about that?!
Worked like a charm.
Thank you very much!!

You're welcome & thanks for the feedback.