Invalid cell reference error in Excel vLookup function - #REF!

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 ?

give a positive ratinggive a negative rating
17 Dec 2020 at 05:43 PM

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.
give a positive ratinggive a negative rating
20 Dec 2020 at 03:12 PM
Share on FacebookShare on TwitterShare on LinkedInSend email
Find us on Facebook
2023 AnswerTabsTermsContact us
How would you rate your experience with AnswerTabs ?
Very badVery good
Thank you for your feedback.