Forum Discussion
Formula Help for importing data IF
Hi, I have two spreadsheets, one is a master planner which I want to feed into individual planners. Master planner is in calender format with a different tab for months January to June. There are...
NikolinoDE Thanks for your response, I have tried to change the formulas to suit what I have already but can't get it to work. The Master Planner and Individual planners are two different worksheets. I have added the support work name for the individual planner on the 'Legend' sheet and also added a date column as referenced in your formula. This is what my formula looks like =IFERROR(IF(VLOOKUP(A3, '[MASTER PLANNER.xlsx]JAN'!$A$3:$E$8, 1, FALSE)=LEGEND!$C$1, VLOOKUP(A3, '[MASTER PLANNER.xlsx]JAN'!$A$3:$E$8, 1, FALSE), ""), "") but the cells are not populating properly. Can you see why this formula does not work?
Would xlookup be useful for this