Hi Folks, I have a large spreadsheet. I need to look up a record based on a given value. For example, think of a spreadsheet with account number in column A as the “key”. Other columns represent the account details. If I know the account number and want to look up the details what would be the best and quickest approach. The spreadsheet could have between 50,000 and 100,000 rows.
Use LookUp DataTable activity.