Formula to lookup Duplicates

[comp764]

Hello everyone


I looking for a formula that will lookup duplicate text or values. I have two columns, A2:A20 has the date and B2:B20 has letter codes. Codes are different letters, like V=vacation, S=Sick-day etc. What I what, is to look for the letter "S" only which will occur only 3 times. It looks something like below.

[pre]

A         B
12/3/12   V
12/6/12   VB
12/10/12  S

[/pre]
So I want this formula to look in column B for the code "S" and then take the date from column A to another sheet named sick-days. So when someone takes a sick-day and I type in the date and "S" I want the date to automatically go to the Sick-day sheet.


Thanks

 

[Luke M]

Check out the article I wrote here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


It describes a technique to pull/lookup entries for a specified criteria. You could easily adapt it to work in this situation.

 

[comp764]

Wow! Thanks Luke, Formula worked great. Did exactly what I needed to do.