Friends,

I have a spreadsheet similar to the following:

A B C
1 Symbol Quant PnL
2 DELL 50
3 INTC 100
4 AMD 200

I have a named Range "Symbol" for cells A2..A4.

I want to select cells C2..C4 using the fact that they are in the column
with the heading of "PnL" and that they correspond to the Range "Symbol".

In other words, I want the code to say, "Select the cells that correspond to
the Range "Symbol" but are in the column with the heading "PnL".

Thanks,
Alan


--
achidsey