VLOOKUP3: Multiple columns with Array

Ctrl+Shift+Enter – Enter function with Array

Useful Excel Keyboard short cuts

Ctrl + F1 Hide/Show the riboon Ctrl + Pagedown move to next worksheet Ctrl + Pageup move to prev. worksheet Arrow keys move from a cell to next cell, direction of arrow Ctrl + Arrow keys move to end of the cell from current position, direction of arrow Shift + Arrow keys Select the sells,…

Leave a Reply

Discover more from this and that @ work

Subscribe now to keep reading and get access to the full archive.

Continue reading