You can easily adapt the lookup formula to return a corresponding value. When LOOKUP can't find a match, it will match the next smallest value. Having a My Account allows you to register your product to validate your limited hardware warranty duration, view your support history and allows us to provide you more personalized support. This works because LOOKUP assumes that values in lookup_vector are sorted in ascending order and always performs an approximate match. Choose to get help or submit a warranty case for one of your previously registered Logitech products. The key to understanding this formula is to recognize that the lookup_value of 2 is deliberately larger than any values that will appear in the lookup_vector. When lookup_value can't be found, LOOKUP will match the next smallest value that is not an error: the last 1 in the array. When it reaches the end of the array, it will 'step back' to the last 1, which corresponds to the last non-empty cell.įinally, LOOKUP returns the corresponding value in result_vector (given as B:B), so the final result is: June 30, 2020. LOOKUP automatically ignore errors, so LOOKUP will scan through the 1s looking for a 2 that will never be found. The lookup_value is given as the number 2. We are using 2 as a lookup value to force LOOKUP to scan to the end of the data. Notice the 1s represent non-empty cells, and errors represent empty cells. Because of this, the serial number is sometimes called a tail number Main article: United Kingdom military aircraft serials In the UK Royal Air Force (RAF) the individual serial takes the form of two letters followed by three digits, e.g., BT308 the prototype Avro Lancaster, or XS903 an English Electric Lightning F.6 at one time based at RAF Binbrook. This array becomes the lookup_array argument in LOOKUP.

B&b royal case serial number