Step-by-step tech tutorials
Nest MATCH inside INDEX, =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)), to look up a value in any direction. Step-by-step example, exact vs approximate match, left and two-way lookups, multiple criteria, error fixes and when to use XLOOKUP instead.
Read the guidePair your phone with your PC over Bluetooth, then turn on Dynamic lock in Settings > Accounts > Sign-in options.…
Open a photo or screenshot, tap the Live Text button, then touch and hold the text to copy, translate, or…
Select your cells, go to Home > Conditional Formatting, pick a rule such as Highlight Cells Rules > Greater Than,…
Type =QUERY(range, "select ... where ...", 1) to filter, sort, and total data in one formula. This guide explains the…