How to search a table and return a value, similar to Vlookup Excel

Hi all,

Is there a WordPress theme or plugin that essentially performs the excel V-lookup or VBA function?

I have a list of names, each is assigned a factor. (example, John assigned a factor of 1.0). My excel function allows the user to select 1-2 people with a drop down menu and excel returns a person(s) with equal or near equal value. For example, enter John with a factor of 1.0, return Mary with a factor of .8 and Tim with a factor of .2

In Excel I’ve wrote some code that performs the following: User enters a person > Excel uses vlookup to determine factor of person > Excel uses another Vlookup to match factor to a different person(s) > Excel returns value of equal or near equal person(s)

Other functions include:

Returns top 3 closest options

Does not return the same value twice

Does not return the name of the person entered

At least one of the returned persons is within .2 factor of the highest entered

Came across this thread from a year ago but wondering if anyone’s found a better solution? or has any suggestions?

Any advice would be great, thanks!