| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get exact matches in a vlookup fomrula
in my vlookup formula, I am finding values that shouldn't have values are
returning the value for the closest match. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i get exact matches in a vlookup fomrula
Set the 4th argument to FALSE or 0:
=VLOOKUP(A1,B1:C10,2,FALSE) =VLOOKUP(A1,B1:C10,2,0) Biff "shark1966" wrote in message ... in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i get exact matches in a vlookup fomrula
That worked great! Thanks. I am now receiving #N/A where there are no values.
How can I force the N/A to 0??? "Biff" wrote: Set the 4th argument to FALSE or 0: =VLOOKUP(A1,B1:C10,2,FALSE) =VLOOKUP(A1,B1:C10,2,0) Biff "shark1966" wrote in message ... in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i get exact matches in a vlookup fomrula
=if(iserror(vlookup(...)),0,vlookup(...))
If you're using xl2007: =iferror(vlookup(...),0) shark1966 wrote: That worked great! Thanks. I am now receiving #N/A where there are no values. How can I force the N/A to 0??? "Biff" wrote: Set the 4th argument to FALSE or 0: =VLOOKUP(A1,B1:C10,2,FALSE) =VLOOKUP(A1,B1:C10,2,0) Biff "shark1966" wrote in message ... in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
| vlookup more than one exact match | Excel Worksheet Functions | |||
| using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
