Hi,

New to this forum so sorry if this has been asked before.

I am thinking about trying to write a formula/function that you can use to find what title best matches the search criteria from a list.

For example, if I had a table looking like this:
James Jack John Jim Jeremy
Money 8 1 6 4 3
Sales 10 20 40 25 40
Call Backs 1 3 3 4 1
Assets 30 10 20 30 20


And I wanted to create a table that I could input various values (IE see below) and see which candidate most closely matches my inputs:
Money 7
Sales 25
Call Backs 3
Assets 20

Then based on the formula in the excel cell I could get an answer telling me that "John" most closely matches all the criteria I inputted.

I am thinking it would require an Index Formula with an internal Match function to identify which cell is needed, yet I am unsure the best way to work this out and then summate who most closely matches based on ALL the criteria.

Could anyone help?

I hope this makes sense, thanks.