"=IF(AND(VLOOKUP(Tallie1!"absent",F:F,F21(MATCH(Tallie1!C:C,P21)))..formula not working.. Looking for the following:<br/>Look for the word 'absent' in a column of worksheet2, if found, look at another column on worksheet 2 for a name, when the name is found, match the name to a column on worksheet1, when matched populate the contents of a cell from worksheet1 ..." If names are not matched then poplate nothing