I'm trying to use vlookup to find sales tax for Texas and insert next to correct city. When I manually type in my formula in each cell, I get the correct value. However when I try and copy my formula down my page, it returns NA error. I can fix this by manually typing in the formula for each cell....but it's like 3000 cells I'd have to do this for. Why is this happening???? Please help! I have attached the file. Thanks! Oh...I have already checked calculations. It's set to automatic.
Last edited by trfountain22; 05-16-2015 at 08:51 PM.
You have to make range absolute
=VLOOKUP(D2,$A$2:$B$2339,2,0)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
See this...
About cell and range references
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I should of said.....I tried that too before I posted message and it gave me a value but they were all the same as the first cell i copied from. But let me try again.
Originally Posted by AlKey
Make sure calculation is set to automatic.
Nevermind! You were right. I thought I did it but did it wrong! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks