I posted a question about this a few weeks ago and was assisted wonderfully by Trebor. I needed assistance creating a formula to look up an employees name in one column and look at another column to tell if they completed a training class. I just had a few questions about the formula that was used and would appreciate any response.
Someone wants me to explain exactly how the formula works. Could you please explain it to me. I've attached a sample spreadsheet of how the formula was used.
IF(ISERROR(VLOOKUP(A3,Sheet2!$C$1:$E$12,3,FALSE)),"",IF(VLOOKUP(A3,Sheet2!$C$1:$E$12,3,FALSE)="TCH - Preceptor Workshop","Yes","No"))
I understand that the Vlookup is looking at the name in cell A3 and checking rows Sheet2!$C$1:$E$12, to see if that name is found in those rows. Why is the three in the formula? And what does the false means? Also, is the purpose of the second if statement to only find out if they person attended? Is there someway that one statement could lookup the name and find out if they attended the workshop? Or, are both statements required. Again, what is the number 3 before FALSE being used for?
Thanks for the reply.