i need allocation fommula

M

maddy2222

New Member
Joined
Mar 24, 2020
Messages
7
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
  5. 2011
  6. 2010
  7. 2007
Platform
  1. Windows
  2. MacOS
allocation
ProductStyle NoSizerspEANQtySite NameBIN NO
Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADII need here bin NO
Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROAD
Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINT
stock
BARCODEBINQty
1223F2-R16-P1559
1223F2-R16-P1628

Attachments
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Is this what your expected results would look like? If not, then show us what is expected.
Book1
ABCDEFGH
1ProductStyle NoSizerspEANQtySite NameSheet2.BIN
2Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADIF2-R16-P15
3Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADIF2-R16-P16
4Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P15
5Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P16
6Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINTF2-R16-P15
7Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINTF2-R16-P16
Sheet4
 
Upvote 0
duplicate
www.mrexcel.com

i need allocation Formula

allocation Product Style No Size rsp EAN Qty Site Name BIN NO Kurti abc 81 CM (XS) 1998 1223 45 CT-AHMEDABAD-AMBAVADI I need here bin Qty Kurti abc 81 CM (XS) 1998 1223 20 CT-NAGPUR-POONAM MALL-VIP ROAD Kurti abc 81 CM (XS) 1998 1223 15 CT-HYDERABAD-G.S.CENTER POINT...
www.mrexcel.com www.mrexcel.com
 
Upvote 0
alansidman said:
Is this what your expected results would look like? If not, then show us what is expected.
Book1
ABCDEFGH
1ProductStyle NoSizerspEANQtySite NameSheet2.BIN
2Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADIF2-R16-P15
3Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADIF2-R16-P16
4Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P15
5Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P16
6Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINTF2-R16-P15
7Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINTF2-R16-P16
Sheet4
Click to expand...
yes
 
Upvote 0
maddy2222 said:
yes
Click to expand...
ProductStyle NoSizerspEANQtySite NameBIN NO
Kurtiabc81 CM (XS)
1998​
1223​
45​
CT-AHMEDABAD-AMBAVADIF2-R16-P15
Kurtiabc81 CM (XS)
1998​
1223​
20​
CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P16
Kurtiabc81 CM (XS)
1998​
1223​
15​
CT-HYDERABAD-G.S.CENTER POINTF2-R16-P16/F2-R16-P15
 
Upvote 0
alansidman said:
Is this what your expected results would look like? If not, then show us what is expected.
Book1
ABCDEFGH
1ProductStyle NoSizerspEANQtySite NameSheet2.BIN
2Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADIF2-R16-P15
3Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADIF2-R16-P16
4Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P15
5Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROADF2-R16-P16
6Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINTF2-R16-P15
7Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINTF2-R16-P16
Sheet4
Click to expand...
please help me its urgent
 
Upvote 0
Bring both tables into Power Query/Get and Transform on the Data Tab. Close and Load to Connection Only. Merge the two tables with a Left Join. Here is the Mcode for that

VBA Code: 
let
    Source = Table.NestedJoin(Sheet1, {"EAN"}, Sheet2, {"BARCODE"}, "Sheet2", JoinKind.LeftOuter),
    #"Expanded Sheet2" = Table.ExpandTableColumn(Source, "Sheet2", {"BIN"}, {"Sheet2.BIN"})
in
    #"Expanded Sheet2"

If you are unfamiliar with Power Query or Mcode, click on the links in my signature block for more information.
 
Upvote 0
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Stock allocation

TABLE-1 ITEM SO Qty Chair 11 i need barcode here Table 5 Chair 1 Chair 16 Table 25 Table 12 TABLE-2 Item Stock Chair 30 same chair i hav 2barcode one barcode is 890000000078890-18qty 890000000077888-22qty Tables 50 899000000067888-25qty 896899000000000- 25qty How to make alocotion How to...
chandoo.org

i need formula for allocation

#1 allocation Product Style No Size rsp EAN Qty Site Name BIN NO Kurti abc 81 CM (XS) 1998 1223 45 CT-AHMEDABAD-AMBAVADI I need here bin NO Kurti abc 81 CM (XS) 1998 1223 20 CT-NAGPUR-POONAM MALL-VIP ROAD Kurti abc 81 CM (XS) 1998 1223 15 CT-HYDERABAD-G.S.CENTER POINT...
chandoo.org

If you have posted the question at more places, please provide links to those as well.

Continued cross-posts without links and duplicate posts will lead to your account being suspended.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Locked
  • Question
i need allocation Formula
Replies
3
Views
177
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,013
Messages
6,122,690
Members
449,092
Latest member
snoom82

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top