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.

Originally Posted by rolltyde12

Okay, this is awesome stuff, but I have one more question. In Formation sheet, If I want it to do the same thing in another column, looking for instances of "Bu", can I do that? Will I need more helper columns?

Thanks.

yes you need more helper columns in Master sheet but you can hide them all if you dont want them to see.

see attached file (col B & C are hidden in Master sheet)

Originally Posted by rolltyde12

When I insert more helper columns, everything on my formations page goes blank. Why is this. It's like it doesn't recognize that a column has been inserted.

yes it will happen so because coloumn references would be changed after inserting new column to Master sheet.
what you have to do is to decide first that how much helper columns you need at maximum (i-e how much values you want to search and return in Formation sheet.)
then implement formula in helper columns and Formation sheet columns.
you can tell me that how many values you want to search in Master and how many columns you need in Formation tab. then I'll make it for you.