hello.
I am trying to return the value (date) of a construction schedule by searching for a specific construction activity ID number. Is there a method I can use which incorporates a text search so that as the schedule grows (cell locations shift down) the lookup function still follows the unique activity ID?
Below is a sample of row of the ID I must search for, and the date I must return (on a separate excel file):
<tbody>
</tbody>
Thanks!!!
I am trying to return the value (date) of a construction schedule by searching for a specific construction activity ID number. Is there a method I can use which incorporates a text search so that as the schedule grows (cell locations shift down) the lookup function still follows the unique activity ID?
Below is a sample of row of the ID I must search for, and the date I must return (on a separate excel file):
A | B | C | D | |
- | Activity ID | Description | Start Date | End Date |
1 | L3S4C10020 | Supporting Walls to UPTS Slab 3 | 19-Jan-14 | 25-Jan-14 |
<tbody>
</tbody>
Thanks!!!