Forum Discussion

Deleted's avatar
Deleted
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.

 

Jo

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)

     

Resources