Jan 29 2018 03:34 AM
Jan 29 2018 03:34 AM
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
Jan 29 2018 04:40 AM
Jo,
I guess you are looking for this:
"SPI "&VLOOKUP(B12,'Projects raw data'!$A$2:$Y$126,22,FALSE)