Excel help

Hello,

I need to formulate the following

row A 0 0 0 1 2 3 4 5

Row B Period end              Period end Period end

Row c Date Date Date Date Date 1 Date Date Date 2

 

   

Output Date 1 Date 2 Date 3 etc

What i need is a formuale that looks along row A and finds the cell that contains a 1. Then i need it to look at row B to the right of the column  containing the 1 and find the cell containing the word Period end. One it finds this i need it to bring back the value in the cell below period end in row C.

Once it has brought back the first date (date 1) in need it to be able to be drageed across and kind on move on from the date one and bring back Date 2 etc 

 

Any help would be great. as i cannot crack this one

By: Adam Sloan

Leave a Reply

Your email address will not be published. Required fields are marked *