I have two tables. Table 1 contains a list of names in Column A. Table 2 contains a names and codes column (Column A and B). I want to take the value from Table 1, Column A, search a range of values from Table 2 (‘Table2’!A3:A83), and return the value of the cell in Column B that corresponds to that matching value. Basically, I want to match the names columns from the two tables and return the value in the code column (Column B) of the second table (Table 2).
I found a good example but am getting a N/A error. Here’s my formula: =HLOOKUP(A4, Table2!A4:A82, MATCH(Table2!B3, Table2!B4:B82, 0), FALSE)