Can anyone advise correct formula if i wanted to look up/match a certain value in a cell from a data range on different sheet. if value is found, will return "OUT", otherwise will leave cell blank... Can xls also look up if list of values will be encoded not in range but in a cell, separated by...