Need your kind advice, request you to look at the sample 2 sheet that is attached.
Sheet 3 is my resultant sheet need to lookup value from sheet 1 & sheet 2.Sheet 1.png
Need your kind advice, request you to look at the sample 2 sheet that is attached.
Sheet 3 is my resultant sheet need to lookup value from sheet 1 & sheet 2.Sheet 1.png
Last edited by amjad831001; 01-07-2019 at 06:04 AM. Reason: Image Attached
Please try at Sheet3 E2 and copy down
Formula:Please Login or Register to view this content.
Works,but this formula is too heavy, original worksheet is taking hours to calculate.
Any other way this can be can will be appreciated.
Thanx
Not sure if this faster.
E3
=IFERROR(INDEX(Sheet1!$C$1:$M$20,MATCH(1,INDEX(1/(Sheet1!$A$1:$A$20=D3)/(Sheet1!$B$1:$B$20=C3),)),MATCH(B3,Sheet1!$C$2:$M$2,)),INDEX(Sheet2!$C$1:$M$20,MATCH(D3,Sheet2!$A$1:$A$20,),MATCH(B3,Sheet2!$C$2:$M$2,)))
Thanx mate, thus was such a help
Can also be done using sumproduct, which is faster also
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks