Excel XLOOKUP and Other Lookup Functions
Language: English
Published by Gtech Publishing, 2020
Series: Book 5 of 5 - Excel 2019 Mastery
- Softcover
- Used
Seller: Better World Books, Mishawaka, IN, U.S.A.Better World Books
AbeBooks seller since August 3, 2006
Condition: Used - Very good
US$ 11.00
Quantity: 1 available
Add to basketItem description from seller
Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.
Seller Inventory # 67615525-6
- Title
- Excel XLOOKUP and Other Lookup Functions
- Author
- George, Nathan
- Publisher
- Gtech Publishing
- Publication year
- 2020
- Condition
- Very Good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 1916211364
- ISBN 13
- 9781916211360
- Item weight
- 0.32 pounds
- Dimensions
- N/A
- Series
- Book 5 of 5: Excel 2019 Mastery
Leverage New Powerful Excel Lookup Functions Released in 2020
Dynamic array formulas represent one of the biggest changes to Excel formulas in years. Maybe the biggest change ever. They enable you to work with multiple return values at the same time in a formula.
XLOOKUP is a new and exciting function that replaces VLOOKUP and addresses most of the limitations of its predecessor. XLOOKUP is so versatile that it also replaces HLOOKUP and the INDEX/MATCH/MATCH combination used for simultaneous vertical and horizontal lookups.
A Detailed Walkthrough of New and Exciting Lookup Functions Recently Released
This book provides comprehensive coverage of several of the newly released dynamic array lookup formulas in more depth, and with more examples, than would have been practical in a general-purpose Excel book.
Learn how to use functions like XLOOKUP, XMATCH, FILTER, SORT, CHOOSE, INDEX etc. VLOOKUP will still be in use for a while as the new dynamic array functions are not available to one-time purchase version of Office users yet. For that reason, this book also covers the good old VLOOKUP in some depth. If you’re looking to skill up on VLOOKUP, then this book is also for you.
Functions can save you a lot of time as they're tried and tested predefined formulas. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.
Included are downloadable Excel practice files to enable you to follow the examples in the book hands-on.
In this book, you'll learn the following:
- How to perform different types of lookups with the new XLOOKUP function.
- How to perform lookups with VLOOKUP (if you still need it).
- How to use the combination of VLOOKUP and CHOOSE to extend the functionality of VLOOKUP.
- How to use INDEX/XMATCH/XMATCH for simultaneous vertical and horizontal lookups.
- How to use the new FILTER function to return multiple values based on a criterion.
- Using the new SORT function with FILTER to return sorted lists.
- Using IFERROR to trap formula errors.
- Using IFNA to trap #N/A errors.
- How to troubleshoot and step through formulas to catch and fix logical errors.
- How to create a drop-down list bound to a data range in your worksheet.
Scroll up and click the Buy Now button on the right side of the page to get started today!
"Synopsis" may belong to another edition of this title.
Better World Books
Mishawaka, IN, U.S.A.
AbeBooks seller since August 3, 2006
Shipping rates within U.S.A.
| Item | 4 to 8 business days | 3 to 5 business days |
|---|---|---|
| First item | US$ 0.00 | US$ 13.00 |
Payment methods
Store description
Better World Books (https://www.BetterWorldBooks.com) is a for-profit, socially conscious business and a global online bookseller that collects and sells new and used books online, matching each purchase with a book donation. Each sale generates funds for literacy and education initiatives in the U.S., the UK, and around the world. Since its launch in 2003, Better World Books has raised $33 million for libraries and literacy, donated over 32 million books, and reused or recycled more than 397 million books.…
Seller's business information
Better World Books Marketplace, Inc.
55740 Currant Road
Mishawaka, IN U.S.A. 46545
Terms of sale
Better World Books (BWB) values your satisfaction and offers you returns within thirty (30) days after the estimated delivery date on most items. All returned items must be in the original condition; used items should include the SKU sticker located on the spine or back of the product.
If you have an incomplete, incorrect, or damaged shipment, please contact our Customer Care team via Abebooks contact seller options before proceeding with the return.Please keep in mind that because we deal mostly in used books, any extra components, such as CDs, DVDs, figurines, or access codes are not included.
Shipping terms
Please allow 1-2 business days for order fulfillment.