Hi, I've got two formulas which work in isolation, but cause an error when added together.
I think it must be to do with the brackets.
Can anyone spot the issue here, please?
This is one formula: =IF(Sheet1!B2="Unique",ROUND(VLOOKUP(UPPER(A3),Sheet2!A:J,6,0),2))
And this is the other: =IF(A3="","",IFERROR(ROUND(VLOOKUP(UPPER(A3),SHEET5!$B$4:$W$104,3,0),2),""))
And I thought this would join them together: =IF(A3="","",IFERROR(IF(Sheet1!B2="Unique",ROUND(VLOOKUP(UPPER(A3),Sheet2!A:J,6,0),2),(ROUND(VLOOKUP(UPPER(A3),SHEET5!$B$4:$W$104,3,0),2),""))))
If you could point it the issue, it would be appreciated - thank you in advance.
I think it must be to do with the brackets.
Can anyone spot the issue here, please?
This is one formula: =IF(Sheet1!B2="Unique",ROUND(VLOOKUP(UPPER(A3),Sheet2!A:J,6,0),2))
And this is the other: =IF(A3="","",IFERROR(ROUND(VLOOKUP(UPPER(A3),SHEET5!$B$4:$W$104,3,0),2),""))
And I thought this would join them together: =IF(A3="","",IFERROR(IF(Sheet1!B2="Unique",ROUND(VLOOKUP(UPPER(A3),Sheet2!A:J,6,0),2),(ROUND(VLOOKUP(UPPER(A3),SHEET5!$B$4:$W$104,3,0),2),""))))
If you could point it the issue, it would be appreciated - thank you in advance.