Forum Discussion

Jadrian88's avatar
Jadrian88
Copper Contributor
Apr 19, 2023

Concat function not working

Hi, everyone the question states:   Use XLOOKUP and the concatenation operator to build the names of the products in the format Brand - Name (productsize) (eg 34183000045, ADVANCEPIERRE FOODS - T...
excel
Excel on Mac
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 19, 2023

Jadrian88 

Additional alternative approach…

the formula you provided is returning TRUE instead of the expected concatenated string.

One issue with your formula is that the second argument of the outer XLOOKUP function should be the lookup array, but it appears that you are using it to build the concatenated string. The third argument of the outer XLOOKUP function should be the return array, which is where you would specify the values to return based on the lookup value.

Here is an example of how you could use XLOOKUP and concatenation to build the desired string:

=XLOOKUP(A7, Products!A2:A9359, Products!C2:C9359) & " - " & XLOOKUP(A7, Products!A2:A9359, Products!D2:D9359) & " (" & XLOOKUP(A7,Products!A2:A9359, Products!I2:I9359) & “)”

This formula uses three separate XLOOKUP functions to find the brand, name, and product size of the product specified in cell A7. These values are then concatenated using the concatenation operator (&) and additional text to build the desired string.

 

I hope this helps! 

Resources