If range_lookup is Real or ignored, the very first column should be sorted alphabetically or numerically. If the main column isn't sorted, the return value could be a thing You do not expect. Both type the 1st column, or use FALSE for an exact match. Whenever you change your spreadsheet https://daltoniheyt.mybuzzblog.com/10717221/helping-the-others-realize-the-advantages-of-เว-บพน-น