Drop down value to be selected from excel_not yet resolved plz help

[vijju7_test]

Hi iam a fresher in automation field.

I have an web based application in which user gives his details in text boxes and dropdowns.
For automation i have supplied all the details in an excel which are:
Name,Location,State,Pin.
But the State field is a drop down field with some predefiend values.I store those state values in excel tab along with name,location,pin.

My requirement is qtp should select the state mentioned in the excels state field from the dropdown.
Im very much need of this........PPz help.

Thanks in advance.......