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

peters93

New Member
Joined
Feb 25, 2019
Messages
1
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!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Trebor76

Well-known Member
Joined
Jul 23, 2007
Messages
4,676
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,329
Members
409,863
Latest member
stacy09
Top