need to do a look up formula
I need to do a lookup in my line items so that I can import the data into a module.
I have a flat hierarchy factory list. I have 2 line items Inbound Qty and Lot Numbers.
I've split them so that I can see:
Factory 1 inbound
Factory 1 Lot Number
Factory 2 Inbound
Factory 2 Lot Number
I'm not sure what formula to use in order to split the data now the way I need it to be done. Also, my Lot Numbers are text formatted and Inbound are Number formatted.