Thread: Why is VLOOKUP returning a value from the row above?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Why is VLOOKUP returning a value from the row above?
If you want an exact match then you need to use a 4th parameter in the
VLOOKUP function and set it to 0 or FALSE.

Hope this helps.

Pete

On Oct 12, 6:48*pm, Summerfun
wrote:
The VLOOKUP function is returning a value exactly one row above the row it
should be using.

Reply With QuoteReply With Quote
 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.
Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.