Problem to show LOOKUPVALUE

Common VLOOKUP Problems

In this article we will address some common problems encountered with the VLOOKUP function such as:

Number entered as text
Inserting columns
Wrong use of TRUE or FALSE for range_lookup argument
Lookup_value not in the first column
Copying formula without absolute reference

In using VLOOKUP, we only need to remember the four needed parameters :

WHAT, WHERE, Column Number, Closest Match

lookup_value – the WHAT parameter, this is what we want to look for
table_array – the WHERE parameter, this is where we want to look, where lookup_value can be found in the leftmost column
col_index_num – the COLUMN NUMBER, this is the column number of the data we want to extract, starting the count from the leftmost column of table_array
[range_lookup] – the CLOSEST MATCH; if TRUE, we want to find the closest or exact match, if FALSE, we only want to find the exact match

Regards,

RacheL Gomez