VLOOKUP
VLOOKUP function says:: +VLOOKUP(What you want to look up,where you want to lookfor it,the coloumnn number in the range containing the value to return,return an approximate or an exact match indicate as 1 or 0) To do blank the error report, followng formula +IFERROR(VLOKUP( ), "")