#### monkey_wrench

##### New Member

- Joined
- Jan 20, 2004

- Messages
- 2

Spreadsheet 2 is a table that I would like to reference spreadsheet 1 using “lookup functions”. Referencing the Manufacture and total hours is an easy reference to make. The problem is automating the lookup for the Start date and Finish date. What I would like it to do for the START DATE is to look for the first hours worked and return the corresponding date, I.E. Manufacture A would be 1/12/04, Manufacture B would be 1/13/04, etc. I would also like to do the same thing for the DATE FINISHED I.E Finish date for Manufacture A would be 1/17/04, man B would be 1/16/04 and Man C would be 1/15/04. how can I do this???????

-----------------------------------------------

Spreadsheet 1

------------------------------------------------

_Date _| A | B | C |

1/12/04 | 4 | 0 | 0 |

1/13/04 | 4 | 2 | 0 |

1/14/04 | 2 | 6 | 1 |

1/15/04 | 0 | 6 | 5 |

1/16/04 | 0 | 5 | 0 |

1/17/14 | 4 | 0 | 0 |

-------------------------------------------

spreadsheet 2

--------------------------------------------

Manuf | start date| finish date| Total hours|

____ ____________________________________

Manu A | 1/12/04 | 1/17/14 | 14

_________________________________________

Manu B | 1/13/04 | 1/16/04 | 19

_________________________________________

Manu C | 1/14/04 | 1/15/04 | 6