INDEX & MATCH - getting #N/A

[itr674]

I have built the example as indicated at http://www.mrexcel.com/tip021.shtml, but am getting #N/A when using the Index-Match function?

It appears the formula is looking is column B for the Match which is OK, I'm just trying to determin why it is not working.

Also, would the tables need to be sorted for this to work?

Book1
	A	B	C	D
1	Emp	Name	Dept
2	A204	Smith	Accoutning
3	A206	Doe	Operations
4	A208	Miller	MIS
5	A210	White	Accounting
6	A212	Young	Manufacturing
7
8
9	Emp	Dept
10	A208	MIS
11	A208	#N/A
12
Sheet1

 

[itr674]

No-I took it off because I was the only one that had it...