Excel help
Closed
kl
-
Jul 6, 2009 at 03:15 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2009 at 09:33 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2009 at 09:33 PM
Related:
- Excel help
- Excel date format dd.mm.yyyy - Guide
- Screenshot in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel without vba - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 6, 2009 at 09:33 PM
Jul 6, 2009 at 09:33 PM
use this formula
the number of rows in my sample sheet is 10 if you have more modify the formula suitably
=IF(ISNA(INDEX($D$2:$D$10,MATCH(E2,$C$2:$C$10),1)),"",INDEX($D$2:$D$10,MATCH(E2,$C$2:$C$10)))
the number of rows in my sample sheet is 10 if you have more modify the formula suitably
=IF(ISNA(INDEX($D$2:$D$10,MATCH(E2,$C$2:$C$10),1)),"",INDEX($D$2:$D$10,MATCH(E2,$C$2:$C$10)))
