how to fetch particular datavalues if table is as follows

[#1]

Hello frns,

Again having problem, please help.

I have three tables as:

Table1                                   Table2                              Table3

pk_Col1     Col2                  pk_Col3     Col4                fk_Col5    fk_Col6  col7

A1     B1                              C1     D1                         A2          C3          E1

A2     B2                              C2     D1                         A4          C1          E2

A3     B3                              C3     D3                         A3          C4         E3

A4     B4                              C4     D3                         A1          C2         E4

SO THE QUERY IS :

i want to access the data from table3 and col7 for the corresponding value of B3 AND D3

means i want to fetch data E3 from table3 what expression i need to use..

please reply as early as possible..

Thanks..

[#2]

Table1                                   Table2                              Table3

pk_Col1     Col2                  pk_Col3     Col4                fk_Col5    fk_Col6  col7

A1     B1                              C1     D1                         A2          C3          E1

A2     B2                              C2     D1                         A4          C1          E2

A3     B3                              C3     D3                         A3          C4         E3

A4     B4                              C4     D3                         A1          C2         E4

i wanna make it like:

          C2     C3

A1      E4       -

A2       -        E1

now provide me the ans and please tell me which sheet object should i use for it..

[Gysbert_Wassenaar]

now provide me the ans

At once, glorious Leader!

Use a pivot table. See attache example.

[#4]

can you please explain ,how it will go on...

[#5]

Sir i don't mean anything wrong, i got my answer thanks for your precious help..