I am trying to get the next job number using vlookup once the first requirement is met.
I am using an If and vlookup statemnt
if((qty*-1)< net, vlookup customer part number,customer part number:Job number,2,false),0)
once this requirement is met i want it to find the next job number.</SPAN>
<TBODY>
</TBODY>
I am using an If and vlookup statemnt
if((qty*-1)< net, vlookup customer part number,customer part number:Job number,2,false),0)
once this requirement is met i want it to find the next job number.</SPAN>
Customer Part Number | qty | NET | Job Number | Part Number | Job Number | ||
S50372-000 | 16 | -4 | 197203-001 | S50372-003 | 197126-001 | ||
S50372-000 | 16 | -9 | 197203-001 | S50372-000 | 197203-001 | ||
S50372-000 | 16 | -11 | 197203-001 | S50433-001 | 197348-001 | ||
S50372-000 | 16 | -14 | 197203-001 | S50433-002 | 197349-001 | ||
S50372-000 | 16 | -21 | 197516-001 | S50433-000 | 197508-001 | ||
S50372-000 | 16 | -26 | 197516-001 | S50372-000 | 197516-001 | ||
S50372-000 | 16 | -31 | 197516-001 | S50433-001 | 197596-001 | ||
S50372-000 | 16 | -52 | 197516-001 | S50433-002 | 197609-001 | ||
S50372-000 | 16 | -95 | 197516-001 | S50372-000 | 197688-001 | ||
S50372-000 | 16 | -31 | 197516-001 | S50421-004 | 197722-001 | ||
S50372-000 | 16 | -31 | 197516-001 | S50433-001 | 197771-001 | ||
S50372-000 | 16 | -31 | 197516-001 | ||||
S50372-000 | 16 | -31 | 197516-001 | ||||
S50372-000 | 16 | -31 | 197516-001 | ||||
<TBODY>
</TBODY>