I am creating an app that shows if you require a visa to visit a country depending on your nationality.
For this I have a CSV file with the data:
- Nationality
- Destination
- Visa (YES, NO)
In my app I have a form, on the one hand a field asks for the nationality and the other the destination, but I can’t find a way to create a formula that compares and searches the CSV file to return the result.
For example, I have in column A (Nationality) = Argentina, column B (Destination) = Thailand, column C (Visa) = No
what I need is some way to perform a search and comparison:
If Nationality is equal to column A and Destination is the same in column B, the result is what is in the same row of column C.
Any ideas?