Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP

VLOOKUP

ResolvedVersion 2007

Thu 13 Aug 2009, 15:42 Delegate Kat said...

Kat has attended:
Excel Advanced course

VLOOKUP

Can I apply a VLOOKUP into a filtered table?

Mon 17 Aug 2009, 13:31 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

VLOOKUP

VLOOKUP

RE: VLOOKUP

Excel articles

Excel tip:

Make macros work in newer versions of Excel