Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |