ADVERTISEMENT
Google AdSense Slot (headerLeaderboard)
Set your Publisher ID in src/config/ads.ts to display live ads.
Google Sheets & Cloud Spreadsheets Mastery• 6 min read
Modern XLOOKUP (Left & Right Lookups)
Harness XLOOKUP for flexible 2-way lookups that look in any direction and never break on column insertions.
The Modern XLOOKUP
XLOOKUP replaces both VLOOKUP and HLOOKUP. It can look left or right, defaults to exact match, and does not break when columns are inserted or deleted.
XLOOKUP Syntax
=XLOOKUP(search_key, lookup_range, return_range, [if_not_found])
-- Example: Find price for SKU in cell A2
=XLOOKUP(A2, Products!A2:A500, Products!C2:C500, "Not Found")ADVERTISEMENT
Google AdSense Slot (inContentBanner)
Set your Publisher ID in src/config/ads.ts to display live ads.
Test Yourself With Exercise
Can XLOOKUP look to the left of the lookup column in a table?