I think this is the most similar case to my case,
http://www.mrexcel.com/forum/excel-q...-criteria.html
{=INDEX(Sheet1!A1:A1000,MATCH(1,(Sheet1!B1:B1000=$ A2)*(Sheet1!C1:C1000=$B2)*(Sheet1!D1:D1000=$C2),0) )}
But I do not understand what {}this mean??




Reply With Quote

Bookmarks