another possibility =if(countif(yourrange,lookupvalue),vlookup(...),"")