Good day all,
Struggling to get the formula below to return a blank value if no exact match or a blank cell is found, I've tried =IFERROR(VLOOKUP(valBranch&valDepartment,tblData,4,FALSE) ,"") but still no joy? Any assistance as always is greatly appreciated, thank you & have a great day - Marco
=VLOOKUP(valBranch&valDepartment,tblData,4,FALSE)
Bookmarks