Vlookup with IF statement?

**tyetd** · 07-17-2012, 02:25 PM

Attached is a simplified version of my data. Difficult to explain. The result I need is: John Doe Attended 1/1/06 The reason that is correct is b/c "Attened" over-rides "not-attended" / "Cancelled" and The newest date wins.

So what Im looking for is a formula I can use which will show me if John Doe attended one of these classes. And if he did when was the most recent class. If he cancelled, when did he cancel, or has he just not attended yet.

Thanks for any help. Sorry its kinda wordy and confusing.

**Haseeb Avarakkan** · 07-17-2012, 04:02 PM

One option is PivotTable, see the attached

**tyetd** · 07-18-2012, 08:44 AM

Thanks Haseeb.
This is a step in the right direction. A pivot table would work except I will need all off the attendance status to be in one column. I personally like your method better, but this report is for someone well above my pay grade and he wants the status in one column. And I dont know how to do that with more than two values in a pivot table. Thanks again for any input.