alan

Posts: n/a

can vlookup be forced to make a case sensitive match?

i have data that is case sensitive, and a vlookup function needs to
differentiate between for examle two values like 'tree' and Tree'.

is it possible to force the vlookup function to match case? thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel	melissa	Excel Worksheet Functions	2	August 19th 05 09:46 PM
make a vlookup using a variable path	Alex St-Pierre	Excel Worksheet Functions	1	March 2nd 05 11:54 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
any way to make vlookup case sensitive?	Dan in NY	Excel Worksheet Functions	5	February 10th 05 09:05 PM
Trying to make cell "date sensitive" to specific date	ebuzz13	Excel Discussion (Misc queries)	1	January 19th 05 11:04 PM

All times are GMT +1. The time now is 01:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us