I need to look for a record in a cell, then if found give me a record from another cell, but ignore blank cells. I tried to use vlookup but I am not sure to make it ignore blank cell. I tried the below but I am still getting blank cell
IF(ISNA(VLOOKUP(B7,'TLS detail Sep 14 - Oct 25 '!D:G,4,FALSE)),"",VLOOKUP(B7,'TLS detail Sep 14 - Oct 25 '!D:G,4,FALSE))
Bookmarks