Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using vlookup to find exact match | Excel Discussion (Misc queries) | |||
using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |