Multiple Search Fuctions

[BingoGeorge]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee[/TD]
[TD]Language [/TD]
[TD]Tested?[/TD]
[/TR]
[TR]
[TD]4256[/TD]
[TD]English[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]4256[/TD]
[TD]French[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]4637[/TD]
[TD]English[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]34256[/TD]
[TD]Madarin[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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