Spreadsheet: 676580d1588874321-select-from-drop-down-and-pull-data-from-different-sheet-transfer-data
Sheet: Transfer

 |  |  |  |  | Extract Data from a Master List
 | MASTER DATA |  |  |  |  |  |  |  |  |  | Extract individual Data
 | Create this. |  |  |  |  |  |  |  |  | You need this
 | Trade Date | Counter | Market | Action | No. of Shares | Share Price | Cost | SGD | Fx | & this | FRO | < [NAME]
1 | 2020-05-02 00:00:00 | FRO | US | Buy | 1200 | 7 | 8426.75 |  | 1.42 |  | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost
2 | 2020-05-03 00:00:00 | DBS | SG | Buy | 1000 | 26 | 26050.076 |  | 1.42 | 1 |  |  |  |  | Change the 1st Index range to meet your
3 | 2020-05-04 00:00:00 | UOB | SG | Buy | 1200 | 15 | 18034.668 |  | 1.42 | 2 |  |  |  |  | Criteria columns.
4 | 2020-05-05 00:00:00 | DBS | SG | Buy | 800 | 24 | 19236.9792 |  | 1.42 | 3 |  |  |  |  | Create as many rows or columns
5 | 2020-05-06 00:00:00 | DIS | US | Buy | 200 | 110 | 22042.372 |  | 1.42 | 4 |  |  |  |  | as you need.
6 | 2020-05-07 00:00:00 | BAC | US | Buy | 800 | 12 | 9626.75 |  | 1.42 | 5 |  | Note where the $ signs & the Look up cell references are. |  |  |  |  |  | [NAME]
7 | 2020-05-08 00:00:00 | FRO | US | Sell | 1125 | 7.5 | 9026.75 |  | 1.42 | Or this > | DBS | < [NAME] Lookup Identifier
8 | 2020-05-09 00:00:00 | DBS | SG | Sell | 1000 | 26.5 | 26551.039 |  | 1.42 | & this | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost | FRO
9 | 2020-05-12 00:00:00 | DIS | US | Sell | 200 | 103 | 20639.6756 |  | 1.42 | 1 |  |  |  |  |  |  |  | DBS
10 | 2020-05-13 00:00:00 | BAC | US | Sell | 800 | 16 | 12826.75 |  | 1.42 | 2 |  |  |  |  |  |  |  | UOB
11 | 2020-05-14 00:00:00 | FRO | US | Buy | 1309 | 11 | 8426.75 |  | 1.42 | 3 |  |  |  |  |  |  |  | DBS
12 | 2020-05-15 00:00:00 | DBS | SG | Buy | 1000 | 26 | 26050.076 |  | 1.42 | 4 |  |  |  |  |  |  |  | DIS
13 | 2020-05-16 00:00:00 | UOB | SG | Buy | 1200 | 15 | 18034.668 |  | 1.42 | 5 |  |  |  |  |  |  |  | BAC
14 | 2020-05-17 00:00:00 | DBS | SG | Buy | 800 | 24 | 19236.9792 |  | 1.42 |  | DBS | < [NAME]
15 | 2020-05-18 00:00:00 | DIS | US | Buy | 200 | 110 | 22042.372 |  | 1.42 |  | Trade Date | Shares Bought | Price | Cost | [NAME] | Price | Cost
16 | 2020-05-19 00:00:00 | BAC | US | Buy | 800 | 13 | 10426.75 |  | 1.42 | 1 |  | You can also create individual tabs for each set of data
17 | 2020-05-20 00:00:00 | FRO | US | Sell | 999 | 6 | 7226.75 |  | 1.42 | 2 |  | Complete one tab then right click the sheets tab name
18 | 2020-05-21 00:00:00 | DBS | SG | Sell | 1000 | 27 | 27052.002 |  | 1.42 | 3 |  | choose Move/Copy select copy, and move to end.
19 | 2020-05-22 00:00:00 | UOB | SG | Sell | 1200 | 17 | 20439.2904 |  | 1.42 | 4 |  | Change the unique lookup identifier for each new tab you create.
20 | 2020-05-23 00:00:00 | DBS | SG | Sell | 800 | 22 | 17633.8976 |  | 1.42 | 5
21 | 2020-05-25 00:00:00 | BAC | US | Sell | 800 | 13 | 10426.75 |  | 1.42
 |  | The Lookup INDEX is always the value you are looking for. The MATCH range is always the Criteria column. The match too cell is the unique identifier. |  |  |  |  |  |  |  |  |  |  | Tip: Build one formula and try to arrange the $ signs to allow a scroll right or
 | 1st Instance> | =IFERROR(INDEX(Lookup Range,MATCH(Match too Cell,[NAME]") |  |  |  |  |  |  |  |  |  |  | a scroll down.
 |  | [NAME] from 2 downwards. Press Shift Ctrl Enter to put the curly brackets in. |  |  |  |  |  |  |  |  |  |  | After finishing one section Copy & Paste the formulas into the next section.
 | 2nd Instance> | { =IFERROR(INDEX(Lookup Range,SMALL(IF(Match Range=Match too Cell,ROW(Match Range)-ROW(INDEX(Match Range,1,1))+1),Lookup Instance Cell#2)),"-")} |  |  |  |  |  |  |  |  |  |  | Highlite all the formulas and use
 | 3rd Instance> | { =IFERROR(INDEX(Lookup Range,SMALL(IF(Match Range=Match too Cell,ROW(Match Range)-ROW(INDEX(Match Range,1,1))+1),Lookup Instance Cell # 3)),"-")} |  |  |  |  |  |  |  |  |  |  | Find/Replace to change the lookup cell $[NAME] to reference $[NAME] instead.