Index, Match and lookups explained (hopefully)

Dear All

I have worked with Excel since 1987 (v2, only 4 fonts per worksheet!)

Some time ago I wrote a basic introduction to using the Match, Index and Lookup functions plus using array functions, I no longer use Excel everyday for work and want to help others to fully use some of Excel's really useful stuff, please note this was based on Excel 2007, may well have changed a bit since then.

Please find attached 3 pdf files, some are rather long and wordy but if you sit down and follow through you should find them helpful

Any comment welcome

Best regards

Hi Michael,

Welcome to the forum!

Great work.

This should be added in Tips & Tutorials section (http://www.excelforum.com/tips-and-tutorials/); however you can send a Private Message to Forum Moderator & request any one to move.

Regards,
AM