Combine vlookup/text within concatenate

[Darren_workforce]

Hello,

I setup the following formula to pull company NPS/CSAT data. My goal is to display both an individual score along with the team average within the same cell. That's the reason I'm using concatenate but if there is a simpler formula to provide everything I need, I'm open. My issue is that results are 8-9 decimal places and not fitting within the designated cell. I've attempted to add the TEXT(#.##,0.00) formula in multiple locations and am just missing something. Please help!!

=CONCAT(VLOOKUP(C1,'CSAT YTD calc'!D2:F99,3,FALSE)&"/"&(VLOOKUP("grand total",'CSAT YTD calc'!D2:F99,3,FALSE)))

Thank you in advance for any assistance.

 

[iggydarsa]

Haven't tested it but give this a try

=CONCAT(TEXT(VLOOKUP(C1,'CSAT YTD calc'!D2:F99,3,FALSE), "#.##,0.00"), "/", TEXT((VLOOKUP("grand total",'CSAT YTD calc'!D2:F99,3,FALSE)), "#.##,0.00"))

 

[Darren_workforce]

Thank you iggydarsa. That was it. OK it goes out the outside of the vllokup, then. Good stuff!! Thank you again.