98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup
Vlookup
Resolved · Low Priority · Version 2007
Wed 17 Jun 2009, 15:34Delegate Rajeev said...
Thu 18 Jun 2009, 13:57Trainer Simon said...
RE: Vlookup
Hi Rajeev,
Thank you for your question.
When creating a Vlookup formula, in the range lookup argument you use False if you want to find an exact match and True if you wanted to find the closest match(if the top row contained ranges eg. 0, 500,100 etc.
If you were to type in 345 if the range lookup is set to false then it wouldn't find it as it is looking for that exact value in the top row. So in this case you would use True.
On the other hand if you were searching for a capital using the Country as your lookup value(first column) then you would use False.
I hope this answers your question.
Regards
Simon
Wed 24 Jun 2009: Automatically marked as resolved.
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:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |
