Thread: inserting text
View Single Post
  #4   Report Post  
Jon1205
 
Posts: n/a
Default

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.