Forum Discussion

Anonymous's avatar
Anonymous
Jan 29, 2018

Help for CONCATENATE function

Hi I would like to join text with results from a formula as follows :   "SPI " + =VLOOKUP(B12,'Projects raw data'!$A$2:$Y$126,22,FALSE)   How can this best be done?   Thanks for advise. ...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jan 29, 2018

Jo,

 

I guess you are looking for this:

"SPI "&VLOOKUP(B12,'Projects raw data'!$A$2:$Y$126,22,FALSE)