I Have a large nested If statement which is making it extremely difficult to carry on in my spreadsheet. Is there a better way to write it?

[Lasoke]

=IF(ISBLANK(B2), " ",IF(B2=$Home.A2,$Home.C2,IF(B2=$Home.A3,$Home.C3,IF(B2=$Home.A4,$Home.C4,IF(B2=$Home.A5,$Home.C5,IF(B2=$Home.A6,$Home.C6,IF(B2=$Home.A7,$Home.C7,IF(B2=$Home.A8,$Home.C8,IF(B2=$Home.A9,$Home.C9,IF(B2=$Home.A10,$Home.C10,IF(B2=$Home.A11,$Home.C11,IF(B2=$Home.A12,$Home.C12,IF(B2=$Home.A13,$Home.C13,IF(B2=$Home.A14,$Home.C14,IF(B2=$Home.A15,$Home.C15,IF(B2=$Home.A16,$Home.C16,IF(B2=$Home.A17,$Home.C17,IF(B2=$Home.A18,$Home.C18,IF(B2=$Home.A19,$Home.C19,“Error”)))))))))))))))))))

As i get farther down the page i noticed some errors because the formula would auto adjust
=IF(ISBLANK(B7), " ",IF(B7=$Home.A7,$Home.C7,IF(B7=$Home.A8,$Home.C8,IF(B7=$Home.A9,$Home.C9,IF(B7=$Home.A10,$Home.C10,IF(B7=$Home.A11,$Home.C11,IF(B7=$Home.A12,$Home.C12,IF(B7=$Home.A13,$Home.C13,IF(B7=$Home.A14,$Home.C14,IF(B7=$Home.A15,$Home.C15,IF(B7=$Home.A16,$Home.C16,IF(B7=$Home.A17,$Home.C17,IF(B7=$Home.A18,$Home.C18,IF(B7=$Home.A19,$Home.C19,IF(B7=$Home.A20,$Home.C20,IF(B7=$Home.A21,$Home.C21,IF(B7=$Home.A22,$Home.C22,IF(B7=$Home.A23,$Home.C23,IF(B7=$Home.A24,$Home.C24,“Error”)))))))))))))))))))

This prints error because it should be searching $Home.A3 but the auto copy has removed everything prior to B7 / A7.

[robleyd]

At a quick glance it seems VLOOKUP might be a solution.

[Wanderer]

=VLOOKUP( B2; $A$2:$C$24; 3; 0)

You may need to put an additional IFERROR around.