Forum Discussion
pulling tax rate from another sheet
Here's a simpler formula that will work
=VLOOKUP(F2,'Table 1'!$C$2:$D$591,2,0)
As noted by Peter and Sergei, though, you have some cities missing from your table, so you'll get an #NA on occasion
You also need to convert the format of that cell (the whole column actually) to "number" or "general"--as you posted it, so presumably as you have it, it's formatted as "Text" and then will do exactly what it's been doing, show you your formula as text.
Here's a simpler formula that will work
=VLOOKUP(F2,'Table 1'!$C$2:$D$591,2,0)
As noted by Peter and Sergei, though, you have some cities missing from your table, so you'll get an #NA on occasion
You also need to convert the format of that cell (the whole column actually) to "number" or "general"--as you posted it, so presumably as you have it, it's formatted as "Text" and then will do exactly what it's been doing, show you your formula as text.
Thanks so much!!!