Sep 20 2022 07:58 PM
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 installs content from a specific column in that table
* if it is not correct, it checks to see if the original cell (E$) matches other content and then does the same table comparison again
There are three potential pieces of data for E4, so I created a multilevel IF statement with the VLOOKUP formulas. As long as there is content in D10, this formula works and I get the desired result. If D10 is blank, the result is #N/A.
Thoughts on how to make that #N/A result in a blank space instead?
The formula:
=IF($E$4="MOQ7",(VLOOKUP(D10,'2ndtabsheet'!A:E,3,0)),(IF($E$4="MOQ5",(VLOOKUP(D10,'2ndtabsheet'!A:E,4,0)),(IF($E$4="MOQ3",(VLOOKUP(D10,'2ndtabsheet'!A:E,5,0)),"")))))
Sep 20 2022 08:10 PM - edited Sep 20 2022 08:50 PM
Solution@Clintonious_AC Use IFERROR. The formula would then look like this:
=IFERROR(........................., "") where you write your formula (without "=") =)on the dots.
Sep 20 2022 08:35 PM
Sep 20 2022 08:10 PM - edited Sep 20 2022 08:50 PM
Solution@Clintonious_AC Use IFERROR. The formula would then look like this:
=IFERROR(........................., "") where you write your formula (without "=") =)on the dots.