Bracket question

[2022]

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.

 

[Fluff]

Like most functions vlookup is not case sensitive, so there is no need to use upper.
Try

=IF(A3="","",IFERROR(IF(Sheet1!B2="Unique",ROUND(VLOOKUP(A3,Sheet2!A:F,6,0),2),ROUND(VLOOKUP(A3,SHEET5!$B$4:$D$104,3,0),2)),""))

 

[2022]

Ok, thank you, Fluff!

 

[Fluff]

Did that do what you wanted?

 

[2022]

Yes - it all fits into once cell. So thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[2022]

No problem.