Look Up

[usace000]

Forgive me for not knowing the correct terminology, but this is what i am trying to accomplish:


I have 200+ worksheets in 1 work book. There are common components in many worksheets. The components I need referenced are in column C. I need the same values pasted in every other column starting in column "F" for 5 columns for every place that the same component is in column C. The values in every other column are different from each other but will be the same for the specific column in each worksheet.

So basically, everywhere Component "X" is in calumn C, I need values "A,B,C,D,E" automatically pasted in every other column starting in column F for 5 columns.

 

[Squad]

It seems like you just need to use a vlookup statement.