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 workbo...
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")
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