Why is my VLOOKUP returning a blank?

If the source value is zero, then VLOOKUP returns 0. Likewise, if the source is blank, then VLOOKUP still returns the value 0. In this case if the length of what VLOOKUP returns is 0, then Excel doesn’t actually do a lookup—it forces a blank to be returned.

Can VLOOKUP return left column?

Vlookup is a useful function in Excel, we can use it to quickly return the corresponding data of the leftmost column in the table. However, if you want to look up a specific value in any other column and return the relative value to the left, the normal vlookup function will not work.

How do I get VLOOKUP to return blank instead of Na?

How to VLOOKUP and return zero instead of #N/A in Excel?

1. Select the cell you want to use VLOOKUP function, and type this formula =IFERROR(VLOOKUP(A13,$A$2:$C$10,3,0),0), drag the autofill handle to the range you need.
2. Click Kutools > Super LOOKUP > LOOKUP from Right to Left.

What does VLOOKUP return if not found?

When VLOOKUP can’t find a value in a lookup table, it returns the #N/A error. The IFERROR function allows you to catch errors and return your own custom value when there is an error. If VLOOKUP returns a value normally, there is no error and the looked up value is returned.

Why is my VLOOKUP not working properly?

The number one most common reason why a Vlookup does not work is because the numbers in your cells are actually text. They look like numbers, you even might have went to format and formatted them as numbers… but trust me they are still text.

Why does VLOOKUP return 0?

When you use VLOOKUP to return a value from a data table, the function does not differentiate between blanks and zero values in what it returns. If the source value is zero, then VLOOKUP returns 0. Likewise, if the source is blank, then VLOOKUP still returns the value 0.

When does VLOOKUP return N?

When VLOOKUP can’t find a value in a lookup table, it returns the #N/A error . You can use the IFNA function or IFERROR function to trap this error. However, when the result in a lookup table is an empty cell, no error is thrown, VLOOKUP simply returns a zero.

Can VLOOKUP return multiple rows?

Vlookup to return multiple corresponding values in one single cell: With Kutools for Excel’s Advanced Combine Rows utiltiy, you can quickly combine multiple duplicate rows into one record based on key columns, and it also can apply some calculations such as sum, average, count and so on for other columns.