I wanted to check the s/no and date code from another workbook.
I have the formula only check for S/No but not both.
IF(ISNA(VLOOKUP(I8,[Warranty.xlsx]ADefect!$G$9:$G$100,1,FALSE)),"-","Yes")
Where I8 the S/No to be checked in Warranty workbook from G9:G100.
The date code in J8 to be checked in Warranty workbook from H9:H100
How can I modify the formula to have both checked & match before execute the Vlookup command? Thanks.
I have the formula only check for S/No but not both.
IF(ISNA(VLOOKUP(I8,[Warranty.xlsx]ADefect!$G$9:$G$100,1,FALSE)),"-","Yes")
Where I8 the S/No to be checked in Warranty workbook from G9:G100.
The date code in J8 to be checked in Warranty workbook from H9:H100
How can I modify the formula to have both checked & match before execute the Vlookup command? Thanks.
Last edited:
