A function that looks up a value in the first column of a table and returns a value from another column in the same row.
Try it with AIVLOOKUP ("vertical lookup") searches down the leftmost column of a range for a key, then returns a value from a column you specify to the right. It is being superseded by XLOOKUP, which is more flexible and can look left.
=VLOOKUP(lookup_value, table_array, col_index_num, FALSE)Usually the value isn't in the first column, types don't match, or you forgot FALSE for an exact match.