Hi

I am writing a VBScript to retrieve data from an excel sheet. I would like to read a record of data based on the value present in the first column. Please suggest what would be an efficeint way of doing this. I was asked to use techniques like caching column names and indexes. But I a not aware of how to do this. Can somebody please provide me a sample code or pointers on how to do it?

Regards
Srinivas