yeah the references did change, its just i wasnt using the formula in the
correct corresponding row as i had begun to do the task manually. Also the
'p' reference is the range name. I just use single letters as its quicker.

"den4673" wrote:

You have me curious...what was the solution? When I copied the formula
down the references changed with it. Also, doesn't the reference to p
in the vlookup have to be a range or range name?