When I am using vlookup excel formula, instead of result I am getting #REF! - Invalid cell reference error. What should I do to make the formula work correctly ?

Hi,

To use VLOOKUP function you have to enter at least the following arguments:

=vlookup(**lookup value**, **table_array**, **column_index_number**, **range_lookup**)

You should check if the table array is set correctly. For example when you need to get the values from the third column in table array,**check if you have enough columns in the table array range**.

If the range of table array is for example C2:D10, which means there are 2 columns, you can't set column index number to 3, because there are not enough columns. When the column index number is greater than table array range, you get an invalid cell reference error with #REF! in the cell.

To use VLOOKUP function you have to enter at least the following arguments:

=vlookup(

You should check if the table array is set correctly. For example when you need to get the values from the third column in table array,

If the range of table array is for example C2:D10, which means there are 2 columns, you can't set column index number to 3, because there are not enough columns. When the column index number is greater than table array range, you get an invalid cell reference error with #REF! in the cell.

Related questions

## How to add side by side rows in excel pivot table ?

## Is CSV excel file Comma or Semicolon separated / delimited ?

## Check if value exists in column more than once or twice - Excel

## How to show Euro, Dollar or Pound sign on right in Excel ?

## Zero value not showing on Excel chart vertical axis - how to display ?

## Move excel chart horizontal axis to bottom - below negative values

## Create two Charts from one Pivot table - add multiple excel charts

Trending questions

Is PLS LCD display good ? Difference between PLS LCD and Amoled Samsung Galaxy A & F better than M series ? What's the difference ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate inverse currency exchange rate ? How to add side by side rows in excel pivot table ? How long does it take for a ship to go through Suez canal ? Man Month calculation - how many man days or man hours ?

Is PLS LCD display good ? Difference between PLS LCD and Amoled Samsung Galaxy A & F better than M series ? What's the difference ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate inverse currency exchange rate ? How to add side by side rows in excel pivot table ? How long does it take for a ship to go through Suez canal ? Man Month calculation - how many man days or man hours ?

2024 AnswerTabsTermsContact us