Sheet 1 Cell Data Population based sheet2 cell data

[petsean007]

hello everyone! I have a quick question about adding onto the formula below, is there a way to integrate this formula...

=IFERROR(INDEX(Sheet2!$AK$3:$AK$13,MATCH($B5,Sheet2!$A$3:$A13,0)),"")

to have it process the below?

to have Sheet 1 column H Populates data from Sheet 2 AK.. unless there is data in AL- then have sheet 1 Column H populate data from Sheet2 AL.

there is an example solution attached

Thankyou!