Location Status Formula Only Working for First Row

[NTell]

I made a spreadsheet to update a location/site status when data is entered into specific cells. Column A is the location by Site ID, column H is the Assigned Tech, and Column I will be a yes or no entry once the work has been completed. I want the site status in L2 to update from "Not Started" to "In Progress" once a tech has been assigned and then "Done" once the done column has been marked. The formula I have seems to be working, but only for the first row. If I enter a Site ID into K2 that is any other row other than row 1, the status is "Not Started" even with data in the Assigned Tech and Done columns. Help please!

[63falcondude]

Try this in L2:

=IF(VLOOKUP(K2,A:I,9,0)="Yes","Done",IF(VLOOKUP(K2,A:I,8,0)<>"","In Progress","Not Started"))

[NTell]

Works like a charm!

[63falcondude]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.