On 26 Aug, 12:22, Jase4now wrote:
I have a spreadsheet that has teachers first names in column A and their last
names in column C. Their room number is in column F. I need to change the
teachers' first & last names based on the room number. The problem I am
encountering is there is about 75 teachers, much more than the IF function
will handle. For some reason when we pull our report out of the system to
Excel, the teachers names are not acurrate to the rest of the report.

Please help.

Jase4now

Use the VLOOKUP function.

You will have to put the room number in column A though and then look
up the room number and return the teachers name. This is because (I
believe) VLOOKUP can only look left to right and not right to left.

Chrisso