if, vlook up iwth a match and then return

“=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, …”

By: d

Leave a Reply

Your email address will not be published. Required fields are marked *