Forum Discussion
Lookup assistance requested.
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 #...
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
