Excel 2010 , MATCH / transfer of data from master to smaller fil

Hi guys ,

Next Q for you ..... Scenario is to transpose certain columns of a master file data (tab 2) into a smaller consolidated table (tab 1)

A subset of data below , but this is 1500+ rows of data

the ? denotes the match up I need to do (Positive or negative to <tab 2>)

So TAB 1 'Merged Sheet'

Column A H I J K

Code Branch 4 Branch 4 Branch 6 Branch 6
Previous Rate Previous Rate
DR ? ? ? ?
CE ? ? ? ?
31 ? ? ? ?
32 ? ? ? ?
J6 ? ? ? ?

Tab 2 'Master Branch'

The is the master data that needs to be lifted and matched where applicable to the above from columns G & L (1578 rows)

Column G L
Branch Code
4 DR
6 DR
6 CE
4 J6

So in the example above Code DR should populate across all instances of branch 4 & 6 (Columns H-K) , whereas code CE should populate just against Branch 6 (Columns J-K) .

As I say , this is just a subset , the branches go right out to branch 31 , and the 'codes' have 1578 permutations . But I think by doing the small subset above , I can then build out the rest of the formula across the remainder of the large table in TAB 1 .

tks in advance as always .

Stephen