XLOOKUP
Find a value in one column and return the match from another.
Practise XLOOKUP
Excel / Functions
Excel functions to practise
Pick a function, see how it works, then try it on live data. Every page has tasks you can check straight away.
VLOOKUP
Search the first column of a table and return a value from the same row.
Practise VLOOKUPSUMIF
Add up the numbers that meet one condition.
Practise SUMIFCOUNTIF
Count the cells that meet a condition.
Practise COUNTIFIF
Return one value when a test is true and another when it isn’t.
Practise IFStart practising now.
Excel Foundations is free, with no sign-up. Your progress is saved in this browser.