I am under a major time crunch with my data, have searched this forum, tried to have MIcrosoft help me, and even tried to hire a consultant from this site. All, thus far, not working or not heard back.

Here's the problem: Need to combine data from 2 sheets both of which have a unique person identifying number, but contain different data. ONe sheet is ID#, date of birth, gender while the other has multiple entries of ID#, procedures, date of service, diagnosis codes. Also need to convert text of "male" or "female" to "M" or "F" and calculate age (in years only) from birthdate.

Have tried to learn the VLOOKUP thing, and DATEIF thing and pivot table ideas but it's totally not working and this project has a severe cut-off with no recourse if not done on time.

Can anyone help? Keep in mind I have virtually no knowledge of Excel and just bought 2007 for this project alone (sorry)