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
Thu 13 Aug 2009, 15:42Delegate Kat said...
Mon 17 Aug 2009, 13:31Trainer Andrew said...
RE: VLOOKUP
Hi Kat
Thank you for your question. The filter won't affect the range in the Vlookup function.
This means that if you apply a filter to a range of data Excel will selectively hide records in the sheet but the underlying range in used by Vlookup function is not filtered so will include results that the filter is hiding.
You may find you can achieve the result you are looking for using pivot tables rather than vlookup.
Do let me know if you have any further questions.
Kind regards,
Andrew
Mon 24 Aug 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:Concatenating Results of FormulasTo concatenate the results of formulas simply add the "&" after the formula or function closing bracket. |
