Try this in N3, assuming your data is on row 3:

=LOOKUP(10^10,A3:L3)

it will give you the value in the last filled cell in the range.

Hope this helps.

Pete

On Apr 17, 9:34*pm, TerryD wrote:
--
ps_comp cvfileps.ps_par cvfileps.qty * *cvfileps_1.ps_par * * * cvfileps_1.qty *cvfileps_2.ps_par * * * cvfileps_2.qty *cvfileps_3..ps_par * * * cvfileps_3.qty *cvfileps_4.ps_par * * * cvfileps_4.qty *cvfileps_5.ps_par * * * cvfileps_5.qty *finished item * total wt
IF you listed these from column A to O the data would be below with an empty
cell between the 1 data. I want formula to search(formula will be in column
N) to find a value if column L is populated then bring that value to N, If L
is Null then lookat J for a value if J is Null then look at H and so on until
it finda a value and the values are not the same. I just want to return the
first value it finds

1065 * *1114504-10 * * *0.1855 *633249 *2 * * * * * * * 1 * * * * * * * 1 * * * * * * * 1 * * * * * * * 1 * * * * * * * 0.371

TerryD