Forum Discussion
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
1 Reply
Jo,
I guess you are looking for this:
"SPI "&VLOOKUP(B12,'Projects raw data'!$A$2:$Y$126,22,FALSE)
