Multiple Search Fuctions

[BingoGeorge]

Employee	Language	Tested?
4256	English	Y
4256	French	N
4637	English	Y
34256	Madarin	N

<tbody>
</tbody>

So I have 2 spreadsheets, where i need to compare multiple values.
Some of the values such as the employee number however its a different language.
how do I set up a lookup and make sure both documents match.
Does employee 4256 match his value in document 2 does it match the tested value in document 2.

thanks

 

[Joyner]

Hello,

I can't tell what you need from your description. Can you provide what in on both documents and what the expected results are. I am guessing a Pivot Table on both and doing the comparison from that, but I'm not sure with what you have outlined.

Thanks

 

[Dryver14]

Excel Workbook
	M	N	O	P	Q	R	S	T	U
4	1256	english	y			1256	english	y	Match
5	4256	french	n			4256	french	n	Match
6	4637	Mandarin	y			4637	english	y	No Match
7	34256	madarin	n			34256	madarin	n	Match
Sheet1