Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training london - Index function
Hi Annabel,
Thanks for the question
You can use the MATCH function to determine the relative position of a value in a range. The INDEX function on the other hand returns the cell value based on its relative position within a range. You can combine the two functions to get almost any piece of information from any table.
Tracy
Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.
These icons can be double-clicked to split the screen at the top left of the cell currently in use.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
