Hi,
I have a request if anyone can help.
In 1 Worksheet (WorksheetA) we have a large matrix of data where each cell is being be calculated using large formulae.
Similar to the example below but a lot more data:
<tbody>
</tbody>
In a separate worksheet (WorksheetB) I am trying to extract data from the matrix however the data being asked to be extracted could change. And I have to lookup and match values from 2 columns. similar to table below.
<tbody>
</tbody>
So by looking up the Product and looking up the section in WorksheetB and matching it to the matrix in WorksheetA.
I know it can be done but am having a mind blank, any help would be so appreciated.
Many Thanks
I have a request if anyone can help.
In 1 Worksheet (WorksheetA) we have a large matrix of data where each cell is being be calculated using large formulae.
Similar to the example below but a lot more data:
A | B | C | D | E | |
1 | 20 | 21 | 22 | 23 | 24 |
2 | 25 | 26 | 27 | 28 | 29 |
3 | 30 | 31 | 32 | 33 | 34 |
4 | 35 | 36 | 37 | 38 | 39 |
5 | 40 | 41 | 42 | 43 | 44 |
<tbody>
</tbody>
In a separate worksheet (WorksheetB) I am trying to extract data from the matrix however the data being asked to be extracted could change. And I have to lookup and match values from 2 columns. similar to table below.
Product | Section | Data | Should Return in Data Col |
A | 1 | ? | 20 |
A | 2 | ? | 25 |
B | 3 | ? | 31 |
B | 2 | ? | 26 |
C | 4 | ? | 37 |
C | 2 | ? | 27 |
<tbody>
</tbody>
So by looking up the Product and looking up the section in WorksheetB and matching it to the matrix in WorksheetA.
I know it can be done but am having a mind blank, any help would be so appreciated.
Many Thanks