Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Grd
 
Posts: n/a
Default How to get an exact mactch with Vlookup

Hi,

I'm using a Vlookup but get a result even if the value I'm looking up is not
the same as the one the table.

I want to get an error if I don't find and exact match. Am I doing something
wrong?

Thanks In advance
Gordon
  #2   Report Post  
 
Posts: n/a
Default

Hi
Make sure you are including the last argument of the function as FALSE,
otherwise an approximate match will do!

--
Andy.


"Grd" wrote in message
...
Hi,

I'm using a Vlookup but get a result even if the value I'm looking up is
not
the same as the one the table.

I want to get an error if I don't find and exact match. Am I doing
something
wrong?

Thanks In advance
Gordon



  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi Gordon

the VLOOKUP function has four parameters, the fourth, if omitted, will allow
the VLOOKUP function do an approximate match ... if you want an exact match
you need to put FALSE or 0 in the fourth parameter.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Grd" wrote in message
...
Hi,

I'm using a Vlookup but get a result even if the value I'm looking up is
not
the same as the one the table.

I want to get an error if I don't find and exact match. Am I doing
something
wrong?

Thanks In advance
Gordon



Reply
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
using vlookup to find exact match Janice Lee via OfficeKB.com Excel Discussion (Misc queries) 3 March 25th 05 03:03 AM
using vlookup - how do I match 2 spreadsheets w/o same exact numb. klondike47 Excel Worksheet Functions 1 February 6th 05 12:01 AM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 01:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 11:43 AM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 09:06 PM


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

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

About Us

"It's about Microsoft Excel"