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.
|