Formula Excel: Following Columns
Introduction
This article aims to explain how to create a formula in Excel for following columns, specifically the CODE, DESCRIPTION, ORDER, QTY (Order QTY), and SHEET. The example provided involves different worksheets.
Context Topic
Key Concepts
In this article, we will cover the following key concepts:
- Formulas in Excel
- Referencing cells and ranges
- Using absolute and relative cell references
Subtitles
This article is divided into the following subsections:
- Setting Up the Workbook
- Creating the Formula
- Applying the Formula Across Multiple Worksheets
Example: Following Columns in Different Worksheets
Code
=IF(SHEET1!A2="Model", SHEET1!B2, IF(SHEET2!A2="Model", SHEET2!B2, ""))
Description
This formula checks the value in cell A2 of the current worksheet (Sheet1 or Sheet2) and if it equals "Model", it returns the value in cell B2 of the corresponding worksheet. If the value in cell A2 is not "Model", it returns an empty string.
Order
Place this formula in the first cell of the column where you want to display the data from the other worksheets.
QTY (Order QTY)
You can adjust the column references (A and B) according to your worksheet layout.
This article demonstrated how to create a formula in Excel to follow columns in different worksheets. The provided example used an IF statement to check the value in cell A2 of the current worksheet and return the corresponding value from the other worksheet if the condition was met.