Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does “Don forget that the 3rd argument of HLOOKUP/VLOOKUP must evaluate to a number between 1 and 51.” mean?

April 26, 2017forget mean vlookup

0

0 Posted

What does “Don forget that the 3rd argument of HLOOKUP/VLOOKUP must evaluate to a number between 1 and 51.” mean?

1 Answer

0

0 Posted

The third argument of HLOOKUP is the column index. If the value of that argument is outside the range 1 and 51, for example 0, SpreadsheetConverter will not calculcate the correct result since you are making a lookup outside the range. This is just a warning.