Forum Discussion
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),"") ...
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.
- Thank you, Nikolino, for your reply and information.
Regards,
Wayne
