All functions that can be used in value lookups.
Conventional lookup method: LOOKUP, VLOOKUP and HLOOKUP.
Advanced lookup method: INDEX & MATCH.
New lookup method: XLOOKUP, CHOOSE, TAKE, DGET and FILTER.

Join this channel to get access to perks:
[ Ссылка ]

Excel & VBA discussion public group 👉 [ Ссылка ]
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗

#Excel #tips #microsoft

свернуть