View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Forrest G. Forrest G. is offline
external usenet poster
 
Posts: 1
Default 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