Forum Discussion
Solved
IF/OR INDEX MATCH STATEMENT
Please, Please Help. I have my last major hurdle to fix on a complicated project I have been trying to get done for way too long between busy times. I am using Windows 10 Enterprise with Excel 365 ...
=IFERROR( INDEX('ITL_Bulk Varieties'!$AK$2:$AK$8, MATCH($C$6,'ITL_Bulk Varieties'!$E$2:$E$8,0)),"") &IFERROR( INDEX('DOMESTIC VARIETIES'!$AK$2:$AK$32, MATCH($C$6,'DOMESTIC VARIETIES'!$E$2:$E$8,0)),"")
Your 1/1/Value worked beautifully. With the Let statement, if the columns on the Varieties tab were to be moved/rearranged, then this statement would have to be updated, correct?
yes if the Brand and Variety columns moved they would need to be updated but you could instead used MATCH() to find the corresponding column index based on the header name.