IF Then statement or another function to look for a value

[TerryD]

--
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

 

[Pete_UK]

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

 

[TerryD]

Thanks Pete_UK but I may have asked the question wrong. I need it to look at
columns D, F, H, J, and L only