D delta Member Mar 15, 2017 #1 i put my formula. it is posible iserror and isblank is use both function in below formula and how it is =IF(LEN(VLOOKUP(A2,Sheet2!A2:C50,2))=0,"",VLOOKUP(A2,Sheet2!A2:C50,2))
i put my formula. it is posible iserror and isblank is use both function in below formula and how it is =IF(LEN(VLOOKUP(A2,Sheet2!A2:C50,2))=0,"",VLOOKUP(A2,Sheet2!A2:C50,2))
shrivallabha Excel Ninja Mar 15, 2017 #2 Maybe like this? =IFERROR(IF(ISBLANK(VLOOKUP(A2,Sheet2!A2:C50,2)),"",VLOOKUP(A2,Sheet2!A2:C50,2)),"")
Maybe like this? =IFERROR(IF(ISBLANK(VLOOKUP(A2,Sheet2!A2:C50,2)),"",VLOOKUP(A2,Sheet2!A2:C50,2)),"")