find attached File
On Wed, Mar 30, 2011 at 4:16 AM, None wrote:
> Hi all. Attached is a workbook that contains 2 sheets. The first is the
> list that the 2nd sheet will refer to. I'd like a formula in col C on sheet
> 2 that looks up each combination and determines if the combination is
> val
Hi Nadine,
See the attached file where I have used the following formula to
achieve the desired result.
=IF(SUMPRODUCT((Sheet1!$A$2:$A$20=Sheet2!$A2)*(Sheet1!$B$2:$B$20=Sheet2!$B2)*1)=0,"Not
Valid","Valid")
Please feel free to revert in case of any issues.
Best Regards,
DILIPandey
On 3/30/11,
try this see if it helps
IF(VLOOKUP(A2,Sheet1!A:B,2,0)=Sheet2!B2,"Valid","Not Valid")
On Wed, Mar 30, 2011 at 4:16 AM, None wrote:
> Hi all. Attached is a workbook that contains 2 sheets. The first is the
> list that the 2nd sheet will refer to. I'd like a formula in col C on sheet
> 2 that
Hi all. Attached is a workbook that contains 2 sheets. The first is the list
that the 2nd sheet will refer to. I'd like a formula in col C on sheet 2 that
looks up each combination and determines if the combination is valid. Does
anyone have any ideas?
Thanks.
Nadine
--
--
