The table that the VLOOKUP function uses to look for and return information from is known as the table_array.
The wrong cell ranges are being referenced for the lookup_value and table array. The image below shows a VLOOKUP entered incorrectly. If you are planning to copy your VLOOKUP to multiple cells, you will need to lock your table. Maybe you are looking to use multiple VLOOKUPs to return different information about a record. The VLOOKUP above should be entered as =VLOOKUP(H3,B3:F11,2,FALSE). If looking for a unique value, enter FALSE for the last argument. The image below shows a VLOOKUP with the range_lookup argument omitted, and the incorrect value being returned. The TRUE value relies on your data being sorted in ascending order to work. This argument is optional, but if left empty, the TRUE value is used. When looking for a unique value, FALSE should be entered for the range_lookup argument. In most cases people are looking for a particular product, order, employee or customer and therefore require an exact match. The last argument of the VLOOKUP function, known as range_lookup, asks if you would like an approximate or an exact match.
