98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - V Lookup
microsoft excel courses - V Lookup
Resolved · Low Priority · Version Standard
Lucy has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course
V Lookup
I learned how to use V lookup on the advanced course, but when I get to the range lookup section, and try to enter 'false', it stops the formula working. It will only work without the false range lookup.
How can I fix this?
thanks
RE: V Lookup
Hi Lucy,
Thanks fot the question, the difference between the TRUE and FALSE setting is:-
If you put TRUE the computer will look for anapproximate match to your generator. The first column of your array must be in order and it will go down the list until it finds a point where the match will stop. For example, if your generator is "10000" it will go down the list until it finds 10000 or anything more than that and it will stop.
If you use the FALSE option it will find the exact match and your first list doesn't have to be in order.
I hope that helps
Tracy
RE: V Lookup
Hi Tracy,
the problem is that the computer displays #VALUE when i add false or true to the end of the formula, it will not let me add this criteria, which I need to use the vlookup. Can you help?
thanks,
Lucy
RE: V Lookup
=VLOOKUP(D9,E12:F16,2,TRUE)
Couple of things to check. Firstly is your first argument (in my case D9) highlighting the value you want to look for. Press F2 and you can see.
Next make sure your range is totally covered by your table(so in my case E12:F16) and that the first column is what you want to look down.
Finally make sure the column value, is correct, starting from 1 where the list is.
Let me know if you have checked each of these
Tracy
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Copying Values Without Formulas in Excel 2010If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method: |