The Problem
You have a list of Product IDs in Sheet1, and a Price List in Sheet2. You need to bring the prices over to Sheet1 based on the ID.
The Easy Way: Use SheetXAI
If you don't want to mess with formulas, the fastest way to do this is simply by asking.
With SheetXAI, you can open the sidebar and type:
Find the price for each product in Column A using the price list in Sheet2.
SheetXAI will instantly write the formula or script for you and fill the cells. It handles the syntax so you can focus on the result.
The Manual Way: The Formulas You Need
To do this manually, you need to use: VLOOKUP.
1. VLOOKUP
Vertical Lookup. Searches for a value in the first column of a table and returns a value in the same row from a specified column.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- lookup_value: The value you want to look up (e.g., the Product ID).
- table_array: The range where the value is located (must start with the ID column).
- col_index_num: The column number in the range that contains the return value.
- [range_lookup]: TRUE for approximate match, FALSE for exact match.
Example: Look for ID in A2, inside range D:E, get value from 2nd col.
Understanding the Logic
- What to look for: The ID in your current row (
A2). - Where to look: The reference table (
D:E). - Which column to grab: The 2nd column (
2). - Exact match?: Yes (
FALSEor0).
The Final Formula:
=VLOOKUP(A2, Sheet2!A:B, 2, FALSE)
Conclusion
Now you know the "classic" way to solve this using formulas. It's a great skill to have.
But for those times when you just want the job done without the mental math, SheetXAI is there to help.
