Vlookup Get Next Value

[chickey]

I am trying to get the next job number using vlookup once the first requirement is meet.

I am stuck as to how to do this. I can not get match to work either.


if((b2*-1)<c2,Vlookup(a2,g:i,2,false),0)

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	0			S50433-000	197508-001
S50372-000	16	-26	0			S50372-000	197516-001
S50372-000	16	-31	0			S50433-001	197596-001
						S50433-002	197609-001
						S50372-000	197688-001
						S50421-004	197722-001
						S50433-001	197771-001​

<TBODY>
</TBODY>

 

[PCL]

Can you give more details:
What will be the next value, where to put this value and why?

 

[chickey]

Can you give more details:
What will be the next value, where to put this value and why?

I am trying to get the next job number using vlookup once the first requirement is meet.

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.