टीप : Smart-phone मध्ये screen Rotate केल्यास file accurate दिसेल.
Advance Excel-Excel-2013
This Topic
Index / Index Match Function
Format
Month = 1 to 12
Amount = 1000 to 9000
Formula
Index
=INDEX (D9:O17,9 ,2)
9 = Amount
2= month
Index Match
=INDEX (B9:M17, MATCH (I19,B9:B17,0),MATCH(I20,B8:N8,0))
No comments:
Post a Comment
Please do not enter ant spam link in the comment box.