I have a CSV of staff IDs and corresponding names and I want some selected persons to enter their staff IDS in Question1 which should have a match in the CSV.
If there is a match, the answer to Question2 which is hidden should be populated with the corresponding name of the entered ID in the CSV list.
If there is no match, user should be prompted to enter correct ID.