I have a workbook with 2 sheets quota and database .
My goal is extract data from database from column A ,D AND G as criteria and lookup column F of same sheet. and insert correct data in column F of quota sheet .
I have taken a small sample as the database is much bigger of 5000 rows .
I used index and match through concatenation as array form. but when I have data in column A and G are same criteria but column D , I am getting N/A .
There is an issue with match concatenation which evaluate N/A.
Can anyone assist I am stuck
=INDEX(DATABASE!$E$2:$E$6,MATCH(A2&D2&G2,DATABASE!$A$2:$A$6&DATABASE!$C$2:$C$6&DATABASE!$F$2:$F$6,0))
Bookmarks