search for a value in one column and find another value from anoth

[Guest]

I have 13 columns with values in each. I want to search each column, each
time I find the value of "p' in a columnI then want to find the name of a
person associated with that row. I have a list on names in column z. So, if
I found a "P" in column 4,row4, I would want to acquire the name from row 4
out in the column Z. There should be 6 occurances of the letter "p" in each
column.

Thanks for any assistance.
Carl

 

[Franz Verga]

I have 13 columns with values in each. I want to search each column,
each time I find the value of "p' in a columnI then want to find the
name of a person associated with that row. I have a list on names in
column z. So, if I found a "P" in column 4,row4, I would want to
acquire the name from row 4 out in the column Z. There should be 6
occurances of the letter "p" in each column.

Thanks for any assistance.
Carl

Hi Carl,

I think you could use Autofilter (menu Data, Filter, Autofilter).


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy