Excel help
Closed
kl
-
6 Jul 2009 à 15:15
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Jul 2009 à 21:33
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Jul 2009 à 21:33
Related:
- Excel help
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Excel clear formatting - Guide
- Arrow keys not working in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
6 Jul 2009 à 21:33
6 Jul 2009 à 21:33
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)))
