Search 1-D Array not working

[altenbach]

Read from spreadsheet file is not meant to read excel files (=proprietary binary file structure), but simple tab delimited ASCII tables (or comma delimited from the way you have it wired). You are completely overreaching here and this will never correctly work!

Export your excel file as csv file and try with that.

[BretD]

save a copy as a text file (tab delimited) and read that in

[JÞB]

AH

Its a data format problem

[yankeesfan88]

Hmm, my excel file is already in CSV format. 

[BretD]

your excel file is already in csv format? The one you uploaded was an excel file, which is denoted by the .xls. To create either a text file or a csv file just open the file in excel and save as either format. Unless you mean that you already have a csv format file that youve been using but didn't upload?

[yankeesfan88]

Yes, the excel data I am using is in CSV format.  I copied and pasted some data into an excel worksheet and did not save it as a CSV.  The CSV data was given to me, so I didn't know you had to change it to save it as a CSV.