Adding a formula after brackets

[Luke_Hively]

 

Hello, I am currently working on windows 10 and have selected an example cell of the one I would like to edit. I am struggling to insert a vlookup formula to pull a price from another workbook after the "[ADD} ." This is an export from a website template the the "[ADD]" function needs to stay for the reimport process.  Any suggestions would be appreciated thank you 

[#2 · Accepted solution]

@Luke_Hively 

You can use a formula of the form

="[ADD]"&VLOOKUP(...)

If you want to round the price to (for example) two decimal places, use

="[ADD]"&TEXT(VLOOKUP(...),"0.00")

[#3]

="[ADD]"&VLOOKUP(..........)

[#4]

Thank you very much it worked perfectly