Hello all,

I have been using Vlookup functions for several years in excel 2003 and love
them. They are one of my favorite functions and I use the all the time. My
office recently upgraded to Office 2007 and I noticed that the Vlookup
function is now case sensitive when it was not in Excel 2003. Does anyone
know if there is an option or a check box that makes the False criteria case
sensitive for text. I am using cell references to search between sheets in a
workbook. The vlookup function looks like this

=VLOOKUP(A2,Sheet1!A1:B16,2,FALSE)
A2 = St Als
the matching value on sheet 1 is ST ALS

The only difference in the values is the case. I never had this problem
with Excel 2003 and now several of my worksheets are being affected because
the case doesn't match between sheets. I have already installed service pack
1 for 2007 as well as the add-ins. Any help would be greatly appreciated.

Thanks