Function Problems

Use VLOOKUP to Return an Exact Ring Cost in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 868 views

Question details

Return the cost associated with each student's ring type using an exact-match lookup formula.

Use VLOOKUP to Return an Exact Ring Cost in Excel
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.
Before you start

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.

Solution 1Recommended

Use an Exact-Match VLOOKUP Formula

Use VLOOKUP to find each ring type in the fixed lookup table and return its cost.

1
Enter the formula

Select C2 and enter =VLOOKUP(B2,$G$10:$H$13,2,FALSE), then press Enter.

2
Copy it down

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.

3
Check the results

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 an Exact-Match VLOOKUP Formula
How the formula works: The 2 returns the second column of the lookup table, and FALSE requires an exact match. VLOOKUP returns the first match if a ring type appears more than once.
Work with spreadsheets in WPS Office

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. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select the workbook.
  2. 2. Check the lookup table: Confirm that G10:G13 contains ring types and H10:H13 contains their costs.
  3. 3. Enter the formula: Select C2, enter =VLOOKUP(B2,$G$10:$H$13,2,FALSE), and press Enter.
  4. 4. Fill the results: Drag the fill handle from C2 down column C, then save the workbook using File > Save.
Use exact-match VLOOKUP with fixed lookup table references.Open and save Microsoft Excel XLSX and XLS files.Work in a familiar spreadsheet interface with a free office suite.
microsoft office alternative - wps office

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.