IF OR help in populating data from sheet 2 to sheet 1

[peters93]

Hello Everyone, have a quick question about adding onto the formula below.
Sheet1 H5=IFEROR(INDEX(Sheet2!$AK$3:$AK$13,MATCH($B5,Sheet2!$A$3:$A13,0)),"")



To have it process the below?


In sheet 2 Column A is a list of companies and AK2 = Total of errors for each of the companies
AL2 = adjusted Total of errors.


I would like To have sheet 1 Column H populate data from Sheet2 AK.. Unless there is data in AL. if there is data in AL, then have sheet 1 Column H populate data from Sheet2 AL, instead of AK.



I believe that I will need to use IF OR but im not too good with combining formulas
any help is really appreciated
thankyou!

 

[Trebor76]

Hi peters93,

Welcome to MrExcel!!

Try this:

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

Note the formula you posted is in error as it's missing a R from the "IFERROR" function.

Thanks,

Robert