• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help on a simple excel formula

K

kamal bhatt

New Member
hi all
want help on a data where i am trying to derive values from cells alligned to a perticular row. the vlookup wont help here as it will need to horizontally look up from the dates and the if formula is too lengthy. please suggest what can be used.
 

Attachments

  • data req.xlsx
    8.5 KB · Views: 4
Hello kamal, and welcome to the forum!

Assuming you don't have merged cells, in B12:
=VLOOKUP($A12,$A$2:$J$7,MATCH(B$11,$A$2:$J$2,0))

Copy to the right and down as needed. Formula matches up both the value in col A and the date above.
 
You must log in or register to reply here.
Back
Top