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

2,275 thoughts on “Excel help

  1. Tisha Gerbatz

    I’d need to examine with you here. Which isn’t one thing I often do! I take pleasure in reading a post that can make individuals think. Also, thanks for allowing me to comment!

  2. ashampoo 3d cad professional 4 review

    I know this if off topic but I’m looking into starting my own blog and was wondering what all is required to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web savvy so I’m not 100% sure. Any recommendations or advice would be greatly appreciated. Many thanks| а

  3. anabolika kaufen

    Greetings! I know this is kind of off topic but I was wondering which blog platform are you using for this site? I’m getting sick and tired of WordPress because I’ve had problems with hackers and I’m looking at alternatives for another platform. I would be awesome if you could point me in the direction of a good platform.

  4. spritze anabole steroide kaufen

    Thank you for sharing excellent informations. Your website is so cool. I’m impressed by the details that you have on this web site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found just the information I already searched all over the place and simply could not come across. What a perfect web site.

  5. Acheter Phentermine HCL en ligne

    With havin so much content and articles do you ever run into any issues of plagorism or copyright infringement? My site has a lot of unique content I’ve either written myself or outsourced but it seems a lot of it is popping it up all over the web without my authorization. Do you know any solutions to help stop content from being stolen? I’d genuinely appreciate it.

Comments are closed.