Dear Forum.

I am looking to get the results from filtering a table to report outside of the table (so I can use to look up against further tables, etc.).

Please see simple file to illustrate what I'm trying to achieve. (For some reason I am currently unable to attach the file. Please see below link to said file on Dropbox).

I am looking to know what formula would be entered into cells A11 thru F11 so that it would report the relevant entry after filtering the table (A16-F31). The intent is that the user will filter the table so that there is only one entry.

As per the example in the simple file, my actual real world file has both text and numbers.

Any insight as to how to best achieve would be greatly appreciated.



https://www.dropbox.com/s/2hnvr5mpdn...ulas.xlsx?dl=0