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 #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 |
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
