VLOOKUP and SUMIFS Local Member in SAP IBP Excel add-in

Hello! I'm wanting to usage a VLOOKUP oregon SUMIFS relation arsenic a Local Member to bring immoderate outer information into my SAP IBP Excel view. I've tried conscionable pasting the outer information into a 2nd tab wrong the aforesaid workbook that has my IBP view, inserting a caller enactment successful the IBP presumption tab, and adding the formula, but erstwhile I deed participate IBP loads for a 2nd and past the enactment that I created disappears. Is it imaginable to bash a VLOOKUP oregon SUMIFS look wrong an IBP presumption that references a tab that doesn't incorporate SAP IBP data? Thanks!