Unfortunately Excel's VLOOKUP() function is not case sensitive.
There is an alternative, extended function called XTNDVLOOKUP() here.
If you follow the instructions and load this function, you can use it to get a case sensitive version.
Using the example I gave, use this in cell C2:
Note that the data must not start on row 1 - this is due to a limitation of the extended vlookup.
Drag the formula down alongside all the cells containing data to be matched in column B.
The formula in cell D2 is
Again, drag this down as many rows as there is data in column B.
This is what the example looks like (case sensitive):
A B C D
2 Card Gold Silver
3 Element Silver 3 juno
4 Agri juno 4 July
5 Bill July 5
6 Stickers Card
The arguments for extended VLOOKUP() are:
The range of cells containing the data to be searched
The value to be searched for or the address of the cell containing the value to be searched for.
Like VLOOKUP, the column to return a result from. However the column number can be negative to return a result from a column to the left of the item found. If the Horizontal and Vertical index values are both zero, the function returns the relative position of the matching item in the list, rather than the item itself, which is what Vlookup() does.
Vertical Index. (defaults to 0)
This allows a result to be returned from a row before or a row after the found item. Useful for returning the next item in a list. For example you can return the item following the one you searched for in the list.
Search instance (defaults to 0)
You can search for the second or third or nth instance of a value in a list. If the value is negative you can search from the end of your range. -1 will find the last instance of a value in the search range.
Match (defaults to TRUE)
Match is TRUE for a case sensitive match and FALSE for case insensitive.