Help for CONCATENATE function

Highlighted
Deleted
Not applicable

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

1 Reply
Highlighted

Jo,

 

I guess you are looking for this:

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