Forum Discussion

Clintonious_AC's avatar
Clintonious_AC
Copper Contributor
Sep 21, 2022
Solved

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...
  • Riny_van_Eekelen's avatar
    Sep 21, 2022

    Clintonious_AC Use IFERROR. The formula would then look like this:

     

    =IFERROR(........................., "") where you write your formula (without "=") ðŸ˜ƒon the dots.

Resources