That trick is Index/Match, a function that can find any value ... then you type in the value you want to search for, in quotes if it's text. You select a table where the table's left-most column ...