Forum Discussion
Solved
Adding a formula after brackets
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
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 Replies
- ="[ADD]"&VLOOKUP(..........)
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")
- Thank you very much it worked perfectly
