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
![]()
Please Login or Register to view this content.
Your assistance in this regard is most appreciated
Bookmarks