Look in the help index for EXACT

--
Don Guillett
SalesAid Software

"mcilwrk" wrote in message
...
I am working on a spreadsheet that counts hours worked on shifts. The
organization has been using codes like "D" for a full dayshift (8 hours)
and
"d" for a short day shift (6 hours) for many years and are reluctant to
change the coding. Is there a special feature of either the COUNTIF or
VLOOKUP function that allows it to differentiate between upper and lower
case
letters?. At the moment, when the functions see either a "D" or "d" it
applies the same value of hours.

Example:

Name Shift Hours
J Doe D 8
B Smith d 6
G Bush D 8
A Gore d 6
Total 28

I am using VLOOKUP to access the hours in a "table" and apply the hours
assigned to a "D" or "d" shift. I am using COUNTIF to count the "D"'s and
"d"'s in a column to see if the total shifts exceed or are less than the
budgeted shifts / hours on any particular calendar day.

I can achieve everything by changing the "d" to an "sd", but as I said,
the
organization / employees have been using "D" and "d" for 20 years and are
very reluctant to change the coding sytem just to help out the scheduler.

Any help would be greatly appreciated.

--
Ken McI