VLOOKUP - Not returning the proper number (Caro)

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

I have this function:
=VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2)
The lookup value is either 5655, WC 255 or WCP36.
The formula brings back the price of the lookup value. It does not bring
back the right price for WC 255 or WCP36 even though they are entered
correctly into the table. It does bring back the right price for the 5655.
Am I doing something wrong?
 
=VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2,FALSE)

Look in HELP for the meaning of the 4th argument (FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Cell above Using Vlookup 2
vlookups returning formulas - not values - in excel 4
vlookup 2 fields 2
Vlookup 5
VLOOKUP source values are a formula result. Getting #N/A 7
Vlookups to return a N/A value 3
VLOOKUP: Wont return value 6
Use Vlookup to store formulas? 6

Back
Top