=IF(VLOOKUP(A12,Procurement!A:N,6,FALSE)="Yes",IF(ISBLANK(VLOOKUP(A12,Procurement!A:N,3,FALSE)),"",VLOOKUP(A12,Procurement!A:N,3,FALSE)),"") I have attached the document in which i believe the formula is wrong. We need to have what ever is 'yes' in the sample section within the procurement tab to transfer to the sample tab. Is this something you can help with? Thanks
Solved by E. J. in 26 mins