1. no
2. sometimes!

You're welcome!

--
Biff
Microsoft Excel MVP


"yogart" . wrote in message
...
Thank you Biff for your time and effort! Very much appreciated.

1) Do you work for Microsoft?
2) Do you sleep? It seems you are alway there with fast response.

Thank and may God bless your day. : )
--
John 3:16-19


"T. Valko" wrote:

Try this:

=IF(INDEX(C570:C1911,MATCH(2,P570:P1911,0))=I6*$B $2,INDEX(C570:C1911,MATCH(2,P570:P1911,0)),I6*$B$2 )


--
Biff
Microsoft Excel MVP


"yogart" . wrote in message
...
I have been struggling and need some more help with this formula. I
would
like to add to it. Here is that formula that we were working with:

=(INDEX(C570:C1911,MATCH(2,P570:P1911,0))=I6*$B$2 )*3

I would like to add an IF statement to the above formula saying :
IF =(INDEX(C570:C1911,MATCH(2,P570:P1911,0))=I6*$B$2 )*3 Equals
3,
then =INDEX(C570:C1911,MATCH(2,P570:P1911,0)) , if false then I6*$B$2

Any help would be appreciated.

Thank you.

--
John 3:16-19


"Pete_UK" wrote:

You're welcome - I've been in the land of nod while you've been
discussing this.

Pete

On Dec 6, 5:38 am, yogart . wrote:
Thank you Pete : ) : ) : )

--
John 3:16-19



"T. Valko" wrote:
Thank you also to Shane.

Hey, let's give Pete a shoutout! He was on the right track too.

--
Biff
Microsoft Excel MVP