G
Guest
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.
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.