I am looking to make this formula less complicated in Google Sheets.

=CONCATENATE(IF(VLOOKUP($E85,'2024 Master Data'!$C:$T,11,0)=0," ",concatenate(char(10),VLOOKUP($E85,'2024 Master Data'!$C:$T,11,0)," ",IF(VLOOKUP($E85,'2024 Master Data'!$C:$T,12,0)=TRUE, ROUND(VLOOKUP($E85,'2024 Master Data'!$C:$T,12,0),2), VLOOKUP($E85,'2024 Master Data'!$C:$T,12,0)))))

• The goal is to reference another sheet called “2024 Master Data” and combine info from multiple cells into 1 cell.

• The first string is wood type and the second string is amount of wood.

• Only if the wood type is not blank do we want to create a new line and display the wood type followed by the amount

  • IF(VLOOKUP($E85,'2024 Master Data'!$C:$T,11,0)=0," ",concatenate(char(10),VLOOKUP($E85,'2024 Master Data'!$C:$T,11,0)," ",...
    

• If the wood type is a number then we want to round it to 2 decimal places, if not we’d want to display the text.

  • IF(VLOOKUP($E85,'2024 Master Data'!$C:$T,12,0)=TRUE, ROUND(VLOOKUP($E85,'2024 Master Data'!$C:$T,12,0),2), VLOOKUP($E85,'2024 Master Data'!$C:$T,12,0))
    

Is there any way to make this less complicated? This formula only pulls 1 wood type and amount of wood. There could be up to 7 types of wood needed so this formula would be 7x.

Ex: A final cell that has 3 wood types would show:

4/4 beech 1.5

6/4 walnut 3.5

8/4 walnut 2.8