How to Use Excel IF Formulas to Copy Selected Rows Between Sheets in WPS Office
Question details
The user needs to return corresponding drawing numbers and titles from Sheet2 to Sheet3 when a marker cell on Sheet1 contains Y, using an Excel IF formula.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is preparing data for Autodesk Dynamo and needs to copy selected rows based on a Y marker in a separate sheet.
- Observed behavior
- The user wants a formula-driven result that returns the matching drawing number and title or a blank instead of manually copying values.
Open the workbook in WPS Office Spreadsheets and identify the Sheet1 marker column, the Sheet2 source data columns, and the Sheet3 destination where the results should appear.
Use an IF Formula on Sheet3 to Return Matching Values
Use this solution when you need a simple formula-based lookup that returns a value from Sheet2 only when the Sheet1 marker cell contains Y.
The IF function checks a condition and returns one value when true and another when false. In this case it returns the corresponding Sheet2 value when the Sheet1 control cell is exactly Y, and returns an empty result otherwise.
Click the Sheet3 tab in WPS Spreadsheets, then click the cell where the first drawing number or title should appear.
Type =IF(Sheet1!C5="Y",Sheet2!A2,"") in the formula bar and press Enter. Adjust Sheet1!C5 to the marker cell and Sheet2!A2 to the source value cell.
Drag the fill handle from the selected cell across the columns and down the rows to apply the formula to the remaining result cells.
Review the returned values and update the Sheet1 check-cell and Sheet2 source-cell references for each column or row if your layout uses different columns.
Use WPS Office Spreadsheets to Pull Selected Rows with Excel IF Formulas
WPS Office Spreadsheets supports the same Excel IF formula syntax, so you can mark rows with Y on one sheet and return matching drawing numbers and titles on another sheet without changing your workbook workflow.
- 1. Download and install WPS Office: Download WPS Office from the official WPS site, install it, and open the workbook containing Sheet1, Sheet2, and Sheet3.
- 2. Click the Sheet3 destination cell: Select Sheet3 and click the cell where you want the first returned drawing number or title.
- 3. Enter the IF formula: Type =IF(Sheet1!C5="Y",Sheet2!A2,"") and press Enter, replacing the references with your marker cell and source value cell.
- 4. Fill the formula and save the workbook: Drag the formula across the required range, verify the returned values, and save the workbook as .xlsx for use in Autodesk Dynamo.
Frequently Asked Questions
Can I return multiple columns from Sheet2 using this formula?
Yes. Place the formula in the first destination cell for each column and change the Sheet2 reference to the corresponding source column, for example Sheet2!B2, while keeping the same Sheet1 marker cell reference.
What happens if the Sheet1 marker cell is blank or contains something other than Y?
The IF condition returns FALSE, so the formula returns the empty result from the final argument and the destination cell looks blank. If you need another value, replace the final empty text argument in the formula.
How do I copy the formula without breaking the references?
Use the fill handle in WPS Spreadsheets to drag the formula down or across. Check whether references should be relative, absolute with $, or mixed before filling, then adjust them as needed.
Does WPS Office save this result in Excel format for Autodesk Dynamo?
Yes. After entering the formulas, click Menu and choose Save As, then select Excel Workbook (.xlsx) to keep the formulas and results compatible with Excel and Autodesk Dynamo.
