[Excel] formula for this problem
Closed
mtsf26
Posts
1
Registration date
Thursday 3 November 2011
Status
Member
Last seen
3 November 2011
-
3 Nov 2011 à 01:26
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Nov 2011 à 09:38
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Nov 2011 à 09:38
Related:
- [Excel] formula for this problem
- Excel mod apk for pc - Download - Spreadsheets
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Formula bar in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Nov 2011 à 09:38
10 Nov 2011 à 09:38
Hi mtsf26,
Try this formula in D3 of Sheet4:
=INDEX(Sheet3!$C$3:$H$8,MATCH(A3,Sheet3!$B$3:$B$8,0),MATCH(B3,Sheet3!$C$2:$H$2,0))
The formula can then be dragged down.
Best regards,
Trowa
Try this formula in D3 of Sheet4:
=INDEX(Sheet3!$C$3:$H$8,MATCH(A3,Sheet3!$B$3:$B$8,0),MATCH(B3,Sheet3!$C$2:$H$2,0))
The formula can then be dragged down.
Best regards,
Trowa
