I'm having an unusual problem with Vlookup. I enter the formula in a cell and it produces the correct result. However when I copy down the displayed result is exactly the same as in the original cell. When looking at the formulas I note that the lookup cell has been incremented correctly. for example:the original formula is:
dragging this down the next row formula is:Code:=VLOOKUP(A2,[Book1]Sheet1!$A$3:$Y$318,25,FALSE)
and so on. However the result for each cell is the same as in the top one. I have noticed however that if in the formula I manually delete 'A3' and type in 'A3' then it produces the correct result so obviously something is going wrong when draging down the formula even though it appears to be correctCode:=VLOOKUP(A3,[Book1]Sheet1!$A$3:$Y$318,25,FALSE)
any idea's?
Last edited by tryer; 03-11-2010 at 06:06 AM.
Can you post a sample of your sheet?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
that will happen if calculation is set to manual
look in tools/options/calculation
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Spot on - Thank you Martin. I don't know how it got changed to manual but changing it to automatic solved the problem.Originally Posted by martindwilson
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks