I'm trying to look up a name within a spreadsheet where two columns must match the two search criteria and the value from the third is returned. For example: A table of 50 rows and 20 columns which the first column may have 10 matches to the first criteria and then I want to find the value in let's say the 5th column for the row from the original 10 matches which matches the name in a second search criteria (which is contained in column 7). Any ideas?