IF Then statement or another function to look for a value
 

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

IF Then statement or another function to look for a value
 

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

IF Then statement or another function to look for a value
 

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


"Pete_UK" wrote:

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