I need some help....

If i have a worksheet and i want to pick out anything in column N that has a
value of "TR" and then return the value of the data that is on the same row
but in column P can this be done?? Does that make sense??