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