Mar 05 2022 11:51 AM - edited Mar 05 2022 11:53 AM
VLOOKUP doesnt distinguish entries starting with R or S in a table
Mar 05 2022 12:06 PM
Please provide detailed information, preferably attaching a sample workbook demonstrating the problem.
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:00 PM
Mar 05 2022 01:36 PM