Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex VLookup Formula
I have two worksheets:
The first sheet contains date ranges that relate to specific "Rounds": Start End Round 3-Apr-10 15-Apr-10 1 20-Mar-10 2-Apr-10 2 6-Mar-10 19-Mar-10 3 20-Feb-10 5-Mar-10 4 The second worksheet contains a list of tasks which include a start date and an end date. I would like to set up a formula that would look at the end date for each task, and automatically assign the proper "Round" number in a separate column, using the data from the first sheet. So for example, if a task has an end date of 5-Apr-10, the formula will insert a 1 in the Round column in that specific row. HELP!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex vlookup function - possible? help! | Excel Worksheet Functions | |||
Complex Vlookup Table | Excel Discussion (Misc queries) | |||
Help with complex VLOOKUP | Excel Discussion (Misc queries) | |||
Help with complex VLOOKUP | Excel Worksheet Functions | |||
Complex VLOOKUP | Excel Discussion (Misc queries) |