Excel help
Closed
kl
-
Jul 6, 2009 at 03:15 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel help
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
1 reply
venkat1926
Jul 6, 2009 at 09:33 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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)))