Prev: Identify Whole Number
Next: Inserting pictures into Excel Sheet at a particular size
From: KC hotmail com> kcrippstein on 24 Feb 2010 16:05
Your final one (D2) has D2 listed twice by mistake. Just remove the
duplicate D2. Should read:
'2009 Returns'!$D$2:$D$5000
instead of
'2009 Returns'!$D$2:$D$2:$D$5000
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"sdav" wrote:

> i tried that and it still isn't working. Do you have another suggestion?
>
> "KC" wrote:
>
> > When you enter the formula, try using Ctrl+Shift+Enter (we call this CSE)
> > instead of just Enter. This appears to be an array formula, which will
> > evaluate what you've specified line by line for rows 2:5000, but it won't
> > work unless you CSE.
> > --
> > Please remember to indicate when the post is answered so others can benefit
> > from it later.
> >
> >
> > "sdav" wrote:
> >
> > > I have 2 spreadsheets (sales and returns) that I want to match 4 columns on
> > > and if they match pull the P column from the Returns spreadsheet. I found
> > > some old posts with a formula I tried to follow, but I get 0 everywhere. I
> > > have no idea what this is doing. Can anyone help me? Thanks,
> > >
> > >
> > > =IF(ISNUMBER(MATCH(1,('2009 Returns'!$A$2:$A$5000=A2)*('2009
> > > Returns'!$B$2:$B$5000=B2)*('2009 Returns'!$C$2:$C$5000=C2)*('2009
> > > Returns'!$D$2:$D$2:$D$5000 =D2),0)),'2009 Returns'!P2,0)
First  |  Prev  | 
Pages: 1 2
Prev: Identify Whole Number
Next: Inserting pictures into Excel Sheet at a particular size