• 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.

How to read data from multiple sheets

G

ganeshm

Member
Hi all,

I am confused and would like to know which formula is better to use, vlookup or index, for the attached sheets. The formula is supposedly required to read different columns and different rows in order to yield result.

I know to use index formula for looking up straight column and row. Would be helpful, if u could guide me for this.

Regards,
ganesh
 

Attachments

  • Planning.xls
    62 KB · Views: 5
Your data structure isn't conducive to Lookup calculation (be it INDEX/Match or VLOOKUP), or any data analysis.

You can write a relatively simple VBA code to accomplish what you are trying to do. However, I'd strongly recommend restructuring your data to flat table.

EDIT: In fact, your sheet1 & 2 should really be the end result and Master should be the starting point.
 
Last edited:
You must log in or register to reply here.
Back
Top