excel table uses Data ref'd from another...

[NCCGRAD]

Hey,

I need to use data that will be referenced from another table in excel. If anyone knows how to please let me know. I cant seem to find the right equation, im not too good with SQL at all.

Thanks again,

Joe

 

[IRstuff]

Say what? Are you using SQL with Excel?

Your problem statement leaves too much to the imagination.

TTFN

FAQ731-376

 

[NCCGRAD]

Sorry for the lack of details. I have attached a copy of the file below. i want to be able to have it so that "sheet 1" shows all the p/n from the other sheets with the same value to show up in its respectice column on "sheet 1"

So all the p/n's that are "animated" show up in the animated column and etc...

thanks again,
JM