Excel functions/formulas

[micheleatnestle]

Hi, I need some assistance on an excel function/formula. My goal is to create a function/ formula to match 3 columns of information. I am trying to match a course name, the date the course was taken, and the id# associated with that date. Any help would be awesome! If you need to see a portion of the spreadsheet, I will email a copy.

 

[Zack Barresse]

Hi there, welcome to the board!

Can you please try to describe your worksheet for us? No need to email anything. Just tell us how your data is structured. Things like, where headers are, which row data starts on, where it goes to, dimensions, data types, etc. Then tell us what you're expecting in the end. You're a bit vague on that end. Matching 3 columns, ok, but matching with what, and where?

For tips on posting your sheet, take a look at this thread.

 

[micheleatnestle]

Wow, that was quick. Thank you. Yep, sorry about the vagueness, it is a monster project and my brain is slowly turning into oatmeal.

I have 4 headers titled Event ID#/ (I assigned a group of text and numbers to the course name) - USA-NUSA-5415-0001
Employee Date (date the employee(s) attended the course) - 06/26/2012
Course Date (date the course was offered) - 6/26/2012
Session ID # (I assigned a number to each date the course was offered) 5415000001

My goal is to sync the Event ID#, Employee Date, and the Session ID#.

For example: Event ID#(course name) USA-NUSA-5415-0001 is offered on 6/26/2012 and 5 employees took the class on that day, how can I automatically assigned the Session ID# associated with that date (6/26/2012) so that the Session ID# is listed 5 times next to 6/26/2012.

I hope this is clear.

Thanks

Michele

 

[micheleatnestle]

Hi Zack,

I haven't heard back from you, so is it safe to assume that there is no answer to my problem? Please advise.

Thanks!

Michele