Most lookups in Google Sheets ignore capital letters, which is usually helpful and sometimes a problem. If "abc" and "ABC" are different codes, VLOOKUP will quietly return the wrong one. This page lis
Google Sheets how-tos: fuzzy matching, duplicates and lookups. Tested formulas you can copy.
Snakbacks builds small, fast Google Sheets tools and writes tested how-to guides at https://www.snakbacks.com
Markdown supported · ⌘↵ to post
No responses yet.