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 |