Hi Guru,
I trying to use Index and match for attached example but fail to show me the correct result.
Can someone help?
This is the formula i used.
![]()
{=INDEX('sheet 1'!E2:G21, MATCH(1, ('sheet 2'!B2='sheet 1'!E2:E21) * ('sheet 2'!I1='sheet 1'!F2:F21), 0))}
Bookmarks