How to pull 5 files data to one colum by look

Closed
Kutta - Mar 10, 2010 at 11:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 10:55 AM
Hello,

Please help me on this issue.

I need a help on excel.....

I have a data which contains some 3000 rows, data which contains Basic, DA component and i need to pull these data from 5 different sheets based on the 5 different dates like (After april 09 & April 08) to cross verify, whether this is appearing correctly or not.

Instead of putting vlookups from 5 different sheets i need to put one formula which should pull the data from 5 sheets based on the 5 different dates.

Can any one help on this, if so am thankful to you guys.

Regards
Kutta
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2010 at 10:55 AM
Could you post a sample file along with how do see things happening ?
you can post it at https://authentification.site or some other site
0