Lookups

Originally Posted by rolltyde12

Hi Starguy, I am attaching a file for you to look at. I need the function to be placed under Ace on the Formation Sheet. I want it to lookup every occurance of the letters "Ac" on the Master Sheet in Column B. Whenever a call has those letters, that cell will be added to Column A on the Formation Sheet. Can you help?

col B in Master sheet is helper. it looks in col C for value "Ac" and if cell in col C contains "Ac" in it, it will assign an incremental number to it in col B.

see the file.