Excel replacing formula with "=#VALUE!"

I'm using the following formula in a spreadsheet: =IFERROR(INDEX('Data Q2 2020'!$A:$A,SMALL(IF('Data Q2 2020'!$H:$H=$K$30,ROW('Data Q2 2020'!$A$3:$A$3000)),ROW('Data Q2 2020'!$38:$38))-2,1),"") ...

excel

NikolinoDE

Platinum Contributor

Sep 18, 2020

Wayne2016

Here you can find information

How to fix the #VALUE! error

https://exceljet.net/formula/how-to-fix-the-value-error

The third-party products that this article discusses are manufactured oe Informed by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.