I have been searching the forum this morning and haven't really stumbled on something that seems to work for my specific situation. I'm trying to figure out how to have excel look at two cells and return the value of a third. Example:
UserID TrainingTitle TrainingCode CompletionDate
john.doe Training ABCD-EF-100 1/15/2009 0:00
john.doe Training1 FALSE 1/16/2009 0:00
I need find a formula that will allow me to grab the User ID and the Completion date (since multiple users could potentially have the same completion date) in order to return the correct training code. I've been looking at VLOOKUP, INDEX, IF's and I'm just not sure which direction would best suite what I am trying to accomplish. I'm sure this should be fairly simple, but any input or help would be greatly appreciated.
Becky
Bookmarks