Thread: inserting text
View Single Post
  #5   Report Post  
CLR
 
Posts: n/a
Default

Try this......... ="Sales Tax
("&vlookup(tax,indirect('&$C$1&'!A2:B17),2,False)& ")"

Vaya con Dios,
Chuck, CABGx3


"Jon1205" wrote in message
...
I tried that. The equation that I used was:

="Sales Tax (vlookup(tax,indirect('&$C$1&'!A2:B17),2,False))"

It just prints everything in quotation marks. If I just use the vlookup
function it will return the 7%, but I would like it to return "Sales Tax

(7%)"

Is That possible?
Thanks

"Dave O" wrote:

Yes! Check out the VLOOKUP() function in Help.