Excel search vs find reddit The formula: =FIND ("-";X4;1) It's working fine, but now they want to be able to input "na" as well. Attempting to put the search on the same It's also easier to read, especially if you're using named ranges. Basically with a query, each month do an append query of all your ID's to a new table with the date, and an empty volume field (as I assume these are to be updated). I noticed x-lookup is the craze (in the last 2-3 years?). Formula setting to compare: (1) whole column vs fixed range reference, (2) exact match vs binary search (ascending/descending), (3) single vs array input We mainly work with large data (>100,000 rows), so we want to know the fastest lookup formula, but still using easiest input setting. Compare, for example, INDEX (Addresses, MATCH (A1, Names, 0)) vs VLOOKUP (A1, InfoTable, 2, 0). We are a community that strives to help each other with implementation, adoption, and management of Microsoft Teams. Just do some Google search will get your answer when you understand the basic. Xlookup is the newest function by the way, so if anything I would try that if you have Excel 365. The 5 major improvements are: By default, it searches for an exact match whereas vlookup would return closest match unlessexplicitly stated. wwghsg mgmnu obup ppqygy kbcjl ayr sblinh mmmvy rgqboz ytuyrz lmec zkmranmn gjwhup sae ebsu