I seriously need help here. Attached is a copy of my document and I have used the following formula:
=IFERROR(INDEX(Data!$F$2:$F$5839,MATCH(1,(Sheet3!A16=Data!A2:A5839)*(Sheet3!D1=Data!H2:H5839)*(Sheet3!L2=Data!K2:K5839),0)),"")
It is supposed to return "A*" but instead, there is no value. Due to the iferror() function, it has shown up as blank in cell L16 in Sheet3.
I have checked the format of the cells as well as tried different functions such as vlookup(), sumproduct(), etc. but nothing worked.
Can you help?
Bookmarks