search for a value in one column and find another value from anoth
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
|