Excel Doubt
Closed
Saravanan
-
Jun 13, 2012 at 04:21 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 17, 2012 at 12:09 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 17, 2012 at 12:09 AM
Related:
- Excel Doubt
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 17, 2012 at 12:09 AM
Jun 17, 2012 at 12:09 AM
sheet 1 data is from A1 to B2
sheet 2 data is fro A1 to C5
now n sheet1 in C1 copy this formula
=TEXT(INDEX(Sheet2!$C$1:$C$5,MATCH(1,(Sheet2!$A$1:$A$5=Sheet1!A1)*(Sheet2!$B$1:$B$5=Sheet1!B1),1)),"dd-mmm-yy")
now INVOKE THIS FORMULA BY CONTROL SHIFT ENTER
copy C1 down
sheet 2 data is fro A1 to C5
now n sheet1 in C1 copy this formula
=TEXT(INDEX(Sheet2!$C$1:$C$5,MATCH(1,(Sheet2!$A$1:$A$5=Sheet1!A1)*(Sheet2!$B$1:$B$5=Sheet1!B1),1)),"dd-mmm-yy")
now INVOKE THIS FORMULA BY CONTROL SHIFT ENTER
copy C1 down
