I have this formula (see below) in Column D, list01 and mayinc are the named cell range.
=IF(ISNA(LOOKUP(1E+100,SEARCH(B1,'2011.xlsx'!list01),'2011.xlsx'!mayinc)),"",LOOKUP(1E+100,SEARCH(B1,'2011.xlsx'!list01),'2011.xlsx'!mayinc))
If I add Column E1 and F1, with Column E being list01 and Column F mayinc, how do I re-write the formula to add the wildcards to replace list01 in the formula below to pull the list01 value from cell E1 and mayinc from F1?
=IF(ISNA(LOOKUP(1E+100,SEARCH(B1,'2011.xlsx'!list01),'2011.xlsx'!mayinc)),"",LOOKUP(1E+100,SEARCH(B1,'2011.xlsx'!list01),'2011.xlsx'!mayinc))
If I add Column E1 and F1, with Column E being list01 and Column F mayinc, how do I re-write the formula to add the wildcards to replace list01 in the formula below to pull the list01 value from cell E1 and mayinc from F1?