In Numbers, I'm trying to enhance a Concatenated formula of multiple VLOOKUP results. I'm currently producing a result of three concatenated answers (each a specific VLOOKUP formula). I would like to double that to six VLOOKUP formulas...Though duplicating the existing formulas, I keep getting errors.
Here is my formula currently:
=CONCATENATE (VLOOKUP($A$3,Hm_Roster :: $A$2:$L$201,4, FALSE),(" '"),(" "),(VLOOKUP($A$3,Hm_Roster :: $A$2:$L$201,5,FALSE)), (""), (", "),(VLOOKUP($A$3,Hm_Roster :: $A$2:$L$201,6,FALSE)))
You likely deducted, "Hm_Roster" is another page inside the document from which the data is being concatenated. Also, likely obvious: in the document I see "exact match" but when I paste the formulas it reads "FALSE"