Specific Cell Value

[pleiadeez7]

Worksheet 1 of my spreadsheet has columns that include 'Employee Name', 'Date', and 'Travel State'. Worksheet 2 is a time sheet form that includes the column 'Travel State'. How can I query the data in Worksheet 1 to populate the Travel State column of the time sheet with the two letter state code entered in Worksheet 1? In other words, if "Employee Name" traveled to "CA" on "03/31/08" (from worksheet 1), how can I get "CA" to populate in the Travel State cells of the Timesheet on worksheet 2?

Boink, boink, boink...that is my head hitting the keyboard! =)

[Dunc3142]

State is looked up based on the name in sheet2