if formula

[shrubfact]

Hello

I am struggling to complete a formula that returns the data in sheet1 a2 if 2 other references are correct . can anyone help with the end part please

=IF(AND(SHEET2!C3<>SHEET1!A4,SHEET1!A7=TODAY),"I want the data in sheet1A2 returned here")

Regards

[ChemistB]

=IF(AND(SHEET2!C3<>SHEET1!A4,SHEET1!A7=TODAY()),sheet1!A2,"")
Does that work for you?

[shrubfact]

Hi Chemist

tried that ...no errors in formula showing.... but nothing is returned ??

Regards

[ChemistB]

Something is not matching up. Either upload an example sheet (Go Advanced>manage Attachments)
or troubleshoot.
Break it down
If you put =SHEET2!C3<>SHEET1!A4 in a cell, is it true or false? If it's false (and you expect true), look for differences
Same with SHEET1!A7=TODAY()

[shrubfact]

Hi Chemist

all looks ok maybe Im doing it all wrong quite new to this see below for example worksheet

Book1.xlsx

Regards

[ChemistB]

Okay,
Sheet2!C3<>Sheet1!A4 is FALSE which makes
AND(SHEET2!C3<>SHEET1!A4,SHEET1!A7=TODAY()) FALSE
which returns ""
Did you want to say
Sheet2!C3=Sheet1!A4?
or
OR(SHEET2!C3<>SHEET1!A4,SHEET1!A7=TODAY())...

In words, what do you want to happen

[shrubfact]

sorry amended example

Book2.xlsx

Regards

[ChemistB]

Same issue. If C3 = zone4 for example, you will return Sheet1!A2

[shrubfact]

oh ok sorry ....... so I want sheet1A2 data returned in sheet2 C4, if sheet2 C3 is the same as sheet1 A4 and sheet1 A7 is todays date

Thanks for your help its all a learning curve for me I thought <> meant "the same as or equal"

[BB1972]

shrubfact,

<> is equivalent to "not equal to" - in your example, A4 in Sheet1 and C3 in Sheet2 are the same. Change one of them to zone2, and see what happens.



Edit:I see you have that now - cool...

[shrubfact]

ahh got it ...now its sorted many thanks to you both