Pulling Data from other workbooks

    Hi,


    i'm having some trouble coming up with a clean way to pull data from another workbook(s). For example, wb 1 contains 3 set of data; column a = alphabets a through z, column b contains month end dates and column c contains a value.


    How do i in wb 2 (new worksheet) only pull in data for letters, a, t, s, b and e based on a date i specify?


    right now i'm using a very messy "sumproduct formula." for example, i'm using sumproduct((daterange=wb1daterange)*(letter=wb1letter)*(wb1.value)


    my end result would be to pullin the value from wb 1 using two or three critierias in wb 2.

    Re: Pulling Data from other workbooks


    this works for me


    =SUMPRODUCT(((([wb2.xlsx]Sheet1!$F$1:$F$26)="a")+(([wb2.xlsx]Sheet1!$F$1:$F$26)="b"))*(([wb2.xlsx]Sheet1!$G$1:$G$26)=G1)*[wb2.xlsx]Sheet1!$H$1:$H$26)


    note the syntax of using OR in SUMPRODUCT

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login