Lookup assistance requested.

[Mark Broughton]

I have tried to use the Hlookup without success.  I am looking for the formula which will populate the Which School column with the appropriate colum that has the street name in.   I keep getting a #N/A in the second column.

Question: Which School is the street in?
Input in Column 1.  Match to where the street is appearing in one of columns 3 through 5.  Trying to consolidate whichever column title has the street in as the answer in column 2.   I've manually answered but am looking for a formula that will do this automatically.
	Which School?	1. School1	2. School2	3. School3
Smith St	2. School2	#N/A	Smith St	#N/A
Jones Street	3. School3	#N/A	#N/A	Jones Street
Wilson Road	1. School1	Wilson Road	#N/A	#N/A

[#2]

Hi Mark,

In this situation, the most appropriate formula is this:

=INDEX($C$1:$E$1,MATCH(A2,C2:E2,0))

Please find it in the attached file.

Haytham