View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
carl43m carl43m is offline
external usenet poster
 
Posts: 22
Default 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