Forum Discussion
Solved
pulling tax rate from another sheet
Hi, I'm trying to pull the tax rate from another sheet based on a match from a cell in the sheet I'm working from. So if the cell reference is found in the other sheet I want it to return the tax rat...
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.
