I have ref numbers in Col A.
Where Col E contains a #N/A, I have tried to set up and index and match formula to find the first value in Col K, that is not blank or zero that matches the ref in Col A in both workbooks
The formula is on book2
=IFERROR(IFNA(E1,INDEX([Book4.xlsx]Sheet1!$K:$K,MATCH(A1,[Book4.xlsx]Sheet1!$A:$A,0))),INDEX([Book4.xlsx]Sheet1!$K:$K,MATCH(A1,[Book4.xlsx]Sheet1!$A:$A,0)))
Your assistance in this regard is most appreciated
Bookmarks