LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Vlookup command not giving the correct result

I have a spread sheet in which I am using vlookup command.
I want and exact match, if I give FALSE for range_lookup it returns the
result #NA and if I omit FALSE it gives the correct result for the first row,
and repeats the same result for the rest of the rows.

Can some one help me as to what is wrong. A visual inspection of my file
suggests that nothing is wrong the required values are there in the table
array.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup not giving correct output houghi Excel Discussion (Misc queries) 3 July 3rd 08 05:28 PM
vlookup not giving correct output Tom Hutchins Excel Discussion (Misc queries) 1 July 3rd 08 03:21 PM
Formula not giving me the right result Steved Excel Worksheet Functions 6 May 10th 06 03:22 AM
Conditional Formatting not giving correct answer... Financial Admin Excel Worksheet Functions 2 January 9th 06 08:40 PM
Create a total based on multiple conditions is not giving correct. Jacob Excel Worksheet Functions 2 November 4th 04 04:07 AM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"