Use VLOOKUP to Return an Exact Ring Cost in Excel
Question details
Return the cost associated with each student's ring type using an exact-match lookup formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Student ring types are listed in column B, and a lookup table in G10:H13 contains ring types and their costs.
- Observed behavior
- Each cell in column C should show the cost for the corresponding ring type while the lookup table stays fixed when the formula is copied.
Check that ring types are in G10:G13 and their corresponding costs are in H10:H13. Confirm that the first student's ring type is in B2 and that C2 is available for the result.
Use an Exact-Match VLOOKUP Formula
Use VLOOKUP to find each ring type in the fixed lookup table and return its cost.
Select C2 and enter =VLOOKUP(B2,$G$10:$H$13,2,FALSE), then press Enter.
Select C2 and drag its fill handle down column C for the remaining students. The B2 reference changes for each row, while $G$10:$H$13 stays fixed.
Compare the returned costs in column C with the ring types and costs in G10:H13. If a cell shows #N/A, check that its ring type matches an entry in column G.

Use XLOOKUP to Return the Ring Cost
Use XLOOKUP as an alternative in an Excel version that supports it.
Find Ring Costs with VLOOKUP in WPS Spreadsheets
Open the workbook in WPS Spreadsheets and use the same exact-match VLOOKUP formula to return and copy each student's ring cost.
- 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select the workbook.
- 2. Check the lookup table: Confirm that G10:G13 contains ring types and H10:H13 contains their costs.
- 3. Enter the formula: Select C2, enter =VLOOKUP(B2,$G$10:$H$13,2,FALSE), and press Enter.
- 4. Fill the results: Drag the fill handle from C2 down column C, then save the workbook using File > Save.

Frequently Asked Questions
Why does the VLOOKUP formula use FALSE?
FALSE requires an exact match for the ring type in B2. Without it, VLOOKUP may use an approximate match and return an incorrect cost.
Why are there dollar signs in $G$10:$H$13?
The dollar signs make the lookup table reference absolute, so it remains G10:H13 when you copy the formula down column C.
What should I check if the formula returns #N/A?
Compare the ring type in column B with the entries in G10:G13. Correct any missing entries or extra spaces so the values match exactly.
Can I use XLOOKUP instead of VLOOKUP?
Yes, if your Excel version supports XLOOKUP. Enter =XLOOKUP(B2,$G$10:$G$13,$H$10:$H$13) in C2 and copy it down.




