Prev: Already exists on the destination workbook
Next: Synchronous scrolling in all sheets of a wokbook.
From: heather on 2 Feb 2009 09:46
Awesome Thank You, again! I didn't know what to put in there to include the
second sheet. I didn't know I could use & for it! Thanks very much once again.

"Glenn" wrote:

> heather wrote:
> > Help! Trying to refernce more cells but this time in different sheets. I have
> > revamped the formula but i can't figure it out here is sample..
> > http://www.savefile.com/projects/808732916
> >
>
> I think this is what you are looking for:
>
> =IF(A3=A2,INDEX(INDIRECT("Sheet2!"&ADDRESS(MATCH(E2,Sheet2!$B$1:$B$40,0)+1,2)&":$B$40"),
> MATCH(A3,INDIRECT("Sheet2!"&ADDRESS(MATCH(E2,Sheet2!$B$1:$B$40,0)+1,1)&":$A$40"),0)),
> INDEX(Sheet2!$B$1:$B$40,MATCH(A3,Sheet2!$A$1:$A$40,0)))
>
First  |  Prev  | 
Pages: 1 2 3 4 5
Prev: Already exists on the destination workbook
Next: Synchronous scrolling in all sheets of a wokbook.