VLookup, Match/Index, Column Offsets and Sumifs functions

Amy Beryl

Board Regular
Joined
May 5, 2011
Messages
54
Hi all -

I have a good handle on the workings of VLookups but when consultants troop through here its all Match/Index, Column Offsets, and Sumifs. Could someone please explain to me the difference and efficiencies of these methods and when to use them. It might be I don't know what I don't know.

Thanks!

Amy
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,113,929
Messages
5,545,082
Members
410,652
Latest member
Zot
Top