inserting text
 

I have a sheet that lists the sales tax of different cities. I want to be
able to inport the specific rate into a cell on another sheet so that it
states

Sales Tax (7.0%)

Is there any way that I can link the percentage to the other sheet so that I
don't have to change it when I change the city in an above cell.

Thanks for any help

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

Although it'd be more helpful if you were more specific, how about a
vlookup combined with a concatenation. This will take a little setup.
For this suggestion you'll have to have the workbook with the tax rates
have the city in column A and the rate in B. For this example, we'll
presume the cities and rates occupy cells A1:B50 on that sheet.

So, supposing that's done and the city is in column A and the tax in
column B on your main sheet:

In cell B2:

="Sales Tax ("&vlookup(A2,'[TheOtherBook]Sheet1'!$A$1:$B$50,2,0)&"%)"

You can omit the % symbol if you already have it on the rates in the
other workbook.


--
carg1
------------------------------------------------------------------------
carg1's Profile: http://www.excelforum.com/member.php...o&userid=15271
View this thread: http://www.excelforum.com/showthread...hreadid=390748

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.

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.

Thanks carg1. That is exactly what I wanted.

"carg1" wrote:


Although it'd be more helpful if you were more specific, how about a
vlookup combined with a concatenation. This will take a little setup.
For this suggestion you'll have to have the workbook with the tax rates
have the city in column A and the rate in B. For this example, we'll
presume the cities and rates occupy cells A1:B50 on that sheet.

So, supposing that's done and the city is in column A and the tax in
column B on your main sheet:

In cell B2:

="Sales Tax ("&vlookup(A2,'[TheOtherBook]Sheet1'!$A$1:$B$50,2,0)&"%)"

You can omit the % symbol if you already have it on the rates in the
other workbook.


--
carg1
------------------------------------------------------------------------
carg1's Profile: http://www.excelforum.com/member.php...o&userid=15271
View this thread: http://www.excelforum.com/showthread...hreadid=390748

No prob, glad to help :)


--
carg1
------------------------------------------------------------------------
carg1's Profile: http://www.excelforum.com/member.php...o&userid=15271
View this thread: http://www.excelforum.com/showthread...hreadid=390748