Forum Discussion
Clintonious_AC
Sep 21, 2022Copper Contributor
3-level IF and VLookup formula is generating a #N/A error
I created a formula that performs the following: * checks for specific content in one cell (E4) * if that is correct, it compares another cell (D10) with a table in the second sheet, and then insta...
- Sep 21, 2022
Clintonious_AC Use IFERROR. The formula would then look like this:
=IFERROR(........................., "") where you write your formula (without "=") 😃on the dots.
Riny_van_Eekelen
Sep 21, 2022Platinum Contributor
Clintonious_AC Use IFERROR. The formula would then look like this:
=IFERROR(........................., "") where you write your formula (without "=") 😃on the dots.
- Clintonious_ACSep 21, 2022Copper ContributorThat was the solution.
Thank you.