Hi there,
I have a schedule on one tab that lists steps in one column and corresponding dates in another.
On the next time, I have an abbreviated schedule with only certain steps from the full schedule . . . I want to right a formula that says if the step on the abbreviated schedule matches the schedule on the first tab, then return the appropriate date.
For example:
TAB 1
Column A: 1000 Steps
Column B: Scheduled Dates
Tab 2
Column A: 450 Steps
Column B: NEED FORMULA TO RETURN THE CORRESPONDING DATE FROM TAB 1
Thank you in advance!
Corcelle