| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup gives incorrect results
I am using vlookup to search for the numbers on the right correlated to the
text on the left (see table below). However whenever I use 14X145 as the input value it always returns the number 74 which is not correct. I have checked to make sure that there are no additional spaces. What is going on? 10X42 42 12X53 53 12X74 74 14X73 73 14X89 89 14X117 117 14X120 120 14X132 132 14X145 145 18X106 106 24X104 104 24X117 117 24X131 131 24X176 176 36X150 150 36X170 170 36X182 182 36X230 230 36X300 300 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup gives incorrect results
The last argument in VLOOKUP is very important. If it is set to FALSE only
exact matches get reported otherwise you get the nearest match. Tell us what your formula is. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Forrest G." <Forrest wrote in message ... I am using vlookup to search for the numbers on the right correlated to the text on the left (see table below). However whenever I use 14X145 as the input value it always returns the number 74 which is not correct. I have checked to make sure that there are no additional spaces. What is going on? 10X42 42 12X53 53 12X74 74 14X73 73 14X89 89 14X117 117 14X120 120 14X132 132 14X145 145 18X106 106 24X104 104 24X117 117 24X131 131 24X176 176 36X150 150 36X170 170 36X182 182 36X230 230 36X300 300 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup gives incorrect results
It is very simple:
=VLOOKUP(H2,$G$30:$H$48,2) Since I am looking only for the exact match, the last arg was omitted. "Bernard Liengme" wrote: The last argument in VLOOKUP is very important. If it is set to FALSE only exact matches get reported otherwise you get the nearest match. Tell us what your formula is. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Forrest G." <Forrest wrote in message ... I am using vlookup to search for the numbers on the right correlated to the text on the left (see table below). However whenever I use 14X145 as the input value it always returns the number 74 which is not correct. I have checked to make sure that there are no additional spaces. What is going on? 10X42 42 12X53 53 12X74 74 14X73 73 14X89 89 14X117 117 14X120 120 14X132 132 14X145 145 18X106 106 24X104 104 24X117 117 24X131 131 24X176 176 36X150 150 36X170 170 36X182 182 36X230 230 36X300 300 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup gives incorrect results
Making the last argument false fixed the problem. thanks
"Bernard Liengme" wrote: The last argument in VLOOKUP is very important. If it is set to FALSE only exact matches get reported otherwise you get the nearest match. Tell us what your formula is. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Forrest G." <Forrest wrote in message ... I am using vlookup to search for the numbers on the right correlated to the text on the left (see table below). However whenever I use 14X145 as the input value it always returns the number 74 which is not correct. I have checked to make sure that there are no additional spaces. What is going on? 10X42 42 12X53 53 12X74 74 14X73 73 14X89 89 14X117 117 14X120 120 14X132 132 14X145 145 18X106 106 24X104 104 24X117 117 24X131 131 24X176 176 36X150 150 36X170 170 36X182 182 36X230 230 36X300 300 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
| VLOOKUP show all results | Excel Worksheet Functions | |||
| Vlookup Returning Same Results on Each Row | Excel Discussion (Misc queries) | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Formatting the Results of VLOOKUP | Excel Worksheet Functions | |||
Hybrid Mode
