=IF(J2="NA",I2,K2) is in L2 on the sheet and returns the correct data in L2. When you copy the statement down the rows change you would expect but the function returns the I2 data for every row in L2, L3, L4, ETC.