I’ve a data with Multiple rows and Columns. Some thing like below:
This is just for a sample. I’ll be having around 20 Columns and 300 rows.
Requirement is: if the user enters the name or picks a name from a list picker, rest of the columns like Place, Occupation, Hobby should populate in labels. In a nutshell - I want the logic of Vlookup or Hlookup in excel. Currently I am creating my CSV File like below:
I am creating the available info in the form of pairs and using “Look up in pairs” to get the data. I feel it is laborious process. Is this the correct way or is there any other easy way to do it?