| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function IF statement | Excel Worksheet Functions | |||
| Function Conflicts with an If/Then Statement | Excel Worksheet Functions | |||
| WORKDAY Function in an IF statement | Excel Worksheet Functions | |||
| Goto statement in an IF function | Excel Worksheet Functions | |||
| Using date function in an if statement | Excel Worksheet Functions | |||
Threaded Mode
