I'm trying to look up a value in the same row depending on the column
header (Product Codes, looking up their prices). I'm just wondering how
people do it so I can drag the forumula down the page and it'll adjust
the row that it's looking in. I tried CELL("ROWS") but that seemed to
reak havic with the formula so then I created a row with the
appropriate row number in it (which I then hid). I figure there has got
to be a better way....

Cheers

Reg