Another way instead of using IF function for more than 7

Hi,

I have 2 column of information. Column A and B with 200 sets of data.

=IF(D14=A27,Sheet1!B27, IF(D14=A28,Sheet1!B28, IF(D14=A29,Sheet1!B29, IF(D14=A30,Sheet1!B30))))

Above is the current formula I have but the IF function can only be up to 7. Is there another way to do this so that I can do that with 200 sets of data?