Mar 05 2021 05:20 AM
Hi,
I make this example to show what I want to do:
I have a table with numbers and a name in column C. For a list of numbers, I want to have the match name where the search value is included between A and B.
I use this function in cell: =IFERROR(XLOOKUP(A6;A$1:A$3;C$1:C$3);XLOOKUP(A6;B$1:B$3;C$1:C$3;"pas trouvé";1))
You can see that the value 21 is not included in the search table and is not included between A and B. I want throw an error or show a message when it's the case.
I put 1 as match_mode in my second call but it works bad because 21 is not included between 22 and 30.
How can I do it ?
Mar 05 2021 05:39 AM