I have used this in the past, but have forgotten how. I would like to create a spread sheet that RECOGNIZES a particular set of characters (a model and year reference) in two columns and auotmatically post a value (price) in another column. In this case (See Attachment) if B is 2005 and D is REF Then G is $12,500, etc.



[attachment deleted by ADMIN to conserve space] Quote from: trusky on December 01, 2015, 11:07:40 AM

I have used this in the past, but have forgotten how. I would like to create a spread sheet that recognizes a particular set of characters (a model and year reference) in two columns and auotmatically post a value (price) in another column. In this case (See Attachment) if B is 2005 and D is REF Then G is $12,500, etc.

So, if Col B is NOT 2005 or Column D is not REF then Column G should be blank, right?  What about if Col B is 2005 but Col D is not REF or if Col B is 2005 but Col D is not REF?

Where the the price value come from?  Is it calculated or looked up somewhere?

You could place this formula in Col G, =IF(B1="2005", IF(D1="REF", PRICE,""),"").  This will put the value of PRICE into cell G1 if both conditions REF & 2005 are present or will be blank if only 1 or neither is present.  However, I don't have enough info to know where to get the price from.