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

One thought on “Excel help

  1. nike air max 97

    There are certainly a variety of details like that to take into consideration. That may be a nice level to bring up. I provide the thoughts above as normal inspiration but clearly there are questions like the one you deliver up the place crucial factor will be working in honest good faith. I don?t know if greatest practices have emerged round issues like that, however I am certain that your job is clearly recognized as a fair game. Both girls and boys really feel the impression of just a moment抯 pleasure, for the rest of their lives.

Leave a Reply

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