How to Index on Columnal data

[melodramatic]

OK, I copied an Index formula earlier, and finally realized it's not working because my data is in columns, not in row. I think, at least.

I've got two separate tables.

Table #1 (Table Name is "W_B3") is used to schedule personnel to work on projects. Each project will have its own line, and on the day of scheduling, you put in the initials of personnel working that project.

Table #2 (Table Name is "W_Techs") is used to show which personnel are scheduled, and the project/equipment for their schedule on any specific day.

My messed-up formula is intended to work in Table #2, by searching the day column in the B3 table, sarching for the Employee initials, and then put in the cell for the project/equipment. The whole thing is mussed up.

I'm putting in a screen capture of what I'm getting as my answers - and hoping that someone can give me a lesson in how to do it right.

Thank you in advance!!!

 

[Fluff]

As you have more than one set of initials in the cell you need to do a wildcard match like

match("*"&[@Employee]&"*",

 

[melodramatic]

OK, I tried the following:

=INDEX(W_B3[Descript],MATCH("*"&[@Employee]&"*",W_B3[Mon]))

And now all of the cells have #N/A (Value not Available to the formula or function)

 

[Fluff]

Try adding 0 as the final argument in the match function.

 

[melodramatic]

=INDEX(W_B3[Descript],MATCH("*"&[@Employee]&"*",W_B3[Mon],0))

And THIS is why I use MrExcel - the fantastic geniuses willing to help out us Excel minions.

Thank you so much, Fluff! The "*"s, along with the "0" did the trick!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.