Vlookup

[jnix612]

Typically by the time I come to the forums I can ask you specifically "how to", however I don't know where to begin because I'm not familar with Vlookup

I have 2 spreadsheets

1. is a list of EE's who took the test either, failed, passed, or incomplete
2. is a list of ALL employees who SHOULD HAVE taken the test

I need to determine:
Failed, incomplete and who did not show up

The data is raw and the fields do not match. Meaning one sheet has last name, first name in one field or vice versa. Also some people used their middle initial one one sheet and did not on the other sheet. So I know some manual eyeballing is going to be required.

Can you point me in the direction of how I should set up this spreadsheet in order to get Excel to do most of the work? I can start researching the "how to" from there if it's something I'm not familar with.

 

[anglais428]

Can you post a sample of your data?

 

[jnix612]

Can you post a sample of your data?

I don't have clearance to post attachments.

 

[ExcelIsEasy]

I don't know I understand you well. It's hard without the sample data but I'll try.

In the simplest case you need only IF function (example 1).
But you write something about manipulating of text. You can try slice text.

I hope this VLOOKUP tutorial will help. Variant 2 should be ok for this case.

You should paste some sample data and I could try to write some formulas for you.