• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fetching values from one sheet to another sheet

Respected Gurus,

I want the formula from a sheet (sheet name - dynamic) which contains dynamic values to another sheet (sheet name - fno).

The details are described in the file attached herewith (file name - sample9)

Thanks and regards!

Su
 

Attachments

  • sample9.xlsx
    23.9 KB · Views: 8
Try,

1] All Criteria Table header D3:N3, must as same as the Source Table header "Dynamic "sheet A1:Y1

2] I revised "FNO" sheet F4 &L4, from "VOL" to "Volume" for demonstration purpose.

3] Then,

In D5 copied across right to H5 and all down:

=IFERROR(OFFSET(Dynamic!$B$1,MATCH($I5,0+RIGHT(Dynamic!$B$1:$B$50,5),0)-(LOOKUP("zz",$D$3:D$3)="PUT"),MATCH(D$4,Dynamic!$A$1:$Y$1,0)-2),"")

And

4] copy and paste formulae from D5:H25 to J5:N25

83187
 

Attachments

  • Offset(By).xlsx
    31 KB · Views: 5
Try,

1] All Criteria Table header D3:N3, must as same as the Source Table header "Dynamic "sheet A1:Y1

2] I revised "FNO" sheet F4 &L4, from "VOL" to "Volume" for demonstration purpose.

3] Then,

In D5 copied across right to H5 and all down:

=IFERROR(OFFSET(Dynamic!$B$1,MATCH($I5,0+RIGHT(Dynamic!$B$1:$B$50,5),0)-(LOOKUP("zz",$D$3:D$3)="PUT"),MATCH(D$4,Dynamic!$A$1:$Y$1,0)-2),"")

And

4] copy and paste formulae from D5:H25 to J5:N25

View attachment 83187

Thank you very much bosco_yip Sir.
 
Back
Top