How do I prevent a formula using a part of the header from recalculating to use the line b

[JasonPrescott]

How do I prevent a formula using a part of the header from recalculating to use the line below it when I drag the formula down to be used on the next line?

I’m using the formula below to add a bunch of cells into a single cell. For example: each cell lists information about a single traveler’s trip; a single row will have all the information necessary. In the formula below let’s assume

S16 contains the traveler’s name “John Smith”
K16 contains the dates of travel “8/25/15-8/27/15”
D16 contains the primary method of travel “AIR”
L16 contains the secondary method of travel “POV”
M16 contains the event title “Charge Card Training”
P2 is a column header that contains the words “Travel Approved”
P16 contains the date the travel was approved “6/30/15

=S16&","&" "&K16&","&" "&D16&" "&L16&","&" "&M16&","&" "&P2&" "&P16

So the cell that contained the formula would contain:

John Smith, 8/25/15-8/27/15, AIR, POV, Charge Card Training, Travel Approved 6/30/15

(Let’s assume the next traveler is traveling on the same date)

This works fine for the first row but when I drag the formula down to use it in the next row (for the next traveler), “P2” changes to P3 and now instead of saying “Travel Approved 6/30/15” on row 2 like it should, it says “6/30/15 6/30/15”.

How do I fix this? Thanks in advance!

[windy58]

You need to make the P2 reference absolute. $P$2

Then drag down.

Windy

[JasonPrescott]

Perfect! That did the trick! Thank you!