Mar 05 2022 11:51 AM - edited Mar 05 2022 11:53 AM
Mar 05 2022 12:43 PM
It works in this example, to distinguish entries with R or S. Note: the VLOOKUP is in the green background cell.
So as @Hans Vogelaar asks, please give some more details on the full situation you have where VLOOKUP is NOT working as expected. I will hazard the guess that it's not VLOOKUP that is at fault, but rather something else is going on.
Mar 05 2022 01:36 PM