Formula Help for importing data IF

lstynes1999 

Thank you for providing more details. It seems there is a small mistake in the formula you provided. Let us correct it.

Assuming your Legend sheet has the Support Worker names in column C and you want to populate data in columns CL, Time, Desc, and Car (Y/N) in the Individual Planner sheet, let's adjust the formula:

=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, 3, FALSE), ""), "")

Here are the changes:

• I replaced the column index 1 with 3 in the second VLOOKUP function. This change means that the formula will retrieve data from the third column (CL) in the Master Planner when there is a match.

Copy this adjusted formula to the Client (CL) column in your Individual Planner sheet and make similar adjustments for the other columns (Time, Desc, Car (Y/N)). Ensure that the ranges and cell references match your actual spreadsheet layout.

If your Excel version supports XLOOKUP, you can use it to achieve the same result.

Here is how you might modify the formula:

=IFERROR(XLOOKUP($A3, '[MASTER PLANNER.xlsx]JAN'!$A$3:$A$8, '[MASTER PLANNER.xlsx]JAN'!$C$3:$C$8, "", 0), "")

In this XLOOKUP formula:

• $A3 is the date in the Individual Planner.
• '[MASTER PLANNER.xlsx]JAN'!$A$3:$A$8 is the date column in the Master Planner.
• '[MASTER PLANNER.xlsx]JAN'!$C$3:$C$8 is the column containing the data you want to retrieve (CL).

This formula checks if the date in the Individual Planner matches any date in the Master Planner and, if so, retrieves the corresponding data from the CL column. If there's no match, it returns an empty string.

You can adapt this formula for the other columns (Time, Desc, Car (Y/N)) by changing the column references accordingly.

Hope this will help you.