Prev: Conditional Formatting for a dashboard with a drop down menu
Next: formula patterns with a gap of two
From: mjwk on 18 Mar 2010 12:55
I am trying to create a formula for the following:

If Col A on worksheet 1 = Col B on worksheet 2 AND Col B on worksheet 1= Col
C on worksheet 2 then the value of cell X equals the value of cell Y.

I need 2 sets of data to match exactly in order to use the value found in a
third location.

Is this possible to do or do I need to break down into multiple steps?

Thanks
From: Pete_UK on 18 Mar 2010 13:11
Try this in cell_X:

=IF(AND(Sheet1!A1=Sheet2!B1,Sheet1!B1=Sheet2!
C1),cell_Y,something_else)

You decide what you want the something_else to be (eg "" or 0).

Hope this helps.

Pete

On Mar 18, 4:55 pm, mjwk <m...(a)discussions.microsoft.com> wrote:
> I am trying to create a formula for the following:
>
> If Col A on worksheet 1 = Col B on worksheet 2 AND Col B on worksheet 1= Col
> C on worksheet 2 then the value of cell X equals the value of cell Y.  
>
> I need 2 sets of data to match exactly in order to use the value found in a
> third location.
>
> Is this possible to do or do I need to break down into multiple steps?
>
> Thanks

 | 
Pages: 1
Prev: Conditional Formatting for a dashboard with a drop down menu
Next: formula patterns with a gap of two