Checking name matches between excel spreadsheets

[404NotFound]

So I inherited a script from a previous programmer. It checked all the names in a spreadsheet against a database, but now that database is no longer active and I must see if any of the names show up in another spreadsheet instead.

Below I have the code to select the first spreadsheet (the one containing the names I want to check) and collect their names.

Would the code for the second spreadsheet (the one I want to search for the names) be similar?

I'm fairly new to programming and especially AutoIt, any help would be greatly appreciated.

Thanks!

$dbName = FileOpenDialog("Please Select Your Query Data Spreadsheet", @MyDocumentsDir & "\", "Microsoft Excel Files (*.xls;*.xlsx)", 1 )

If @error Then

MsgBox(4096,"","No File(s) chosen")

EndIf

; Open the file into an Excel Instance

$oExcel = _ExcelBookOpen($dbName)

; Make the desired sheet active, ::HARDCODED::

_ExcelSheetActivate($oExcel,"Monthly_Queries")

; Pull the sheet into the big array

$result = _ExcelReadSheetToArray($oExcel, 1, 1, 0, 0)

; Close the Excel instance

_ExcelBookClose($oExcel)

; Count the number of people to query

$numEntries = UBound($result)

[BrewManNH]

The second sheet should be opened and read in a similar way, just changing the name of the array and variables for the second sheet.

[404NotFound]

What function should I use to search for a match once I have the spreadsheet arrays? I'm hoping to be able to find any individual name matches from a large list of names.

[404NotFound]

Also thank you for your help Brewman

[BrewManNH]

I'd use either _ArraySearch, or the version of _ArrayBinarySearch that's in the modified _Array.au3 file linked in my signature, this one will search a 2D array while the original will only work on a 1D array. You'd have to sort the array before searching it to use the binary search function, but it's probably over 100 times faster than the ArraySearch routine.