Sunday, February 19, 2023
HomeLaptopThe best way to use XLOOKUP in Google Sheets

The best way to use XLOOKUP in Google Sheets


Google Sheets is principally a calculator on steroids. It permits you to course of each textual content and quantity knowledge in an infinite variety of methods. Among the many greatest instruments of Google Sheets is the XLOOKUP, which helps you discover values in your tables straight away. XLOOKUP works by looking your knowledge set and returning a worth from the identical row however in a special vary. It’s the proper software for sifting by way of lots of of rows for particular gadgets or a variety of things. There are a selection of the way this might assist you keep away from handbook knowledge searches, however consider it as a cataloging software. A used automobile vendor, for instance, has all of their completely different fashions of vehicles and their corresponding costs in a single Sheet. With XLOOKUP, they’ll robotically slim down a variety of vehicles inside a specified worth vary. Interested by how one can incorporate XLOOKUP into your individual productiveness routine? Learn on!

Utilizing Google Sheet’s XLOOKUP perform

1. Open your Google Sheet along with your desk array and choose the cell you’ll put the perform in. 

(Picture credit score: Laptop computer Magazine)

2. Subsequent, sort in your perform within the following format: =XLOOKUP(search_key, lookup_range, result_range, [missing_value], [match_mode], [search_mode])

(Picture credit score: Laptop computer Magazine)

Search_key: the worth that might be used to go looking your desk array. You too can enter one other cell to make your search key dynamic.

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments