View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
teec_detroit teec_detroit is offline
external usenet poster
 
Posts: 1
Default vlookup -- Upper case and Lower case text

How can you differentiate between upper case and lower case text in a vlookup
function? For me, vlookup returns the first value when I have te last
variable set to "FALSE". I have one row as "I 18" and the next row as "i
4". When I use vlookup for I, the result is 18. When I use vlooup for i,
the result is 18. If I put "i 4" above "I 18", both results are 4. If I set
the last variable to TRUE, the result is always the value of the lower case
"4" regardless of the row order.