I was hoping someone could take a look at the attached workbook and let me know what I'm doing wrong.
I'm trying to do a lookup on a table where a row is matched by doing a logical test on each column. The row I want is the one that tests true for all columns.
I'm using the match function and array functions to do the test.
Thanks for any help you can provide.
Dave
Bookmarks