Try
=INDEX(DataArray!B:B,IFERROR(MATCH(D:D,DataArray!A:A,0),IFERROR(MATCH(B:B,DataArray!A:A,0),MATCH(AA,DataArray!A:A,0))))
Try
=INDEX(DataArray!B:B,IFERROR(MATCH(D:D,DataArray!A:A,0),IFERROR(MATCH(B:B,DataArray!A:A,0),MATCH(AA,DataArray!A:A,0))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks