EXCEL idiot

[beividepabs]

Hello All,

I hope someone can help and excuse my ignorance.

I have tried to get a function working to sort out a problem I have.

I have a database that has a column containing email addresses. I need to compare each email address on column I from Sheet1 with all email addresses from Sheet3 (A2, A3, A4 onwards) and return "sent" if = and "to be sent" if not.

I have tried (possibly incorrectly) VLOOK UP AND IF but not joy.
e.g =IF(Sheet3!A:A=Sheet1!I2,"SENT","TO BE SENT ")

Can someone help?

 

[VoG]

Try in Sheet1 row 2 copied down

=IF(ISNUMBER(MATCH(I2,Sheet3!A:A,0)),"Sent","To be sent")

 

[jeffreybrown]

Hello & Welcome to the Board,

Maybe try...

=IF(ISNUMBER(MATCH(I2,Sheet3!A:A,0)),"Sent","To be Sent")

 

[tc88]

Hello All,

I hope someone can help and excuse my ignorance.

I have tried to get a function working to sort out a problem I have.

I have a database that has a column containing email addresses. I need to compare each email address on column I from Sheet1 with all email addresses from Sheet3 (A2, A3, A4 onwards) and return "sent" if = and "to be sent" if not.

I have tried (possibly incorrectly) VLOOK UP AND IF but not joy.
e.g =IF(Sheet3!A:A=Sheet1!I2,"SENT","TO BE SENT ")

Can someone help?

VLOOKUPs aren't my speciality but try this, but change the A50 to however long your A column on sheet 3 is:

=VLOOKUP(Sheet1!I2,Sheet3!A2:A50,1,FALSE)

 

[manojrf]

Hi,

I think you are gonna put all the e-mail address ( the main data ) in column A of sheet 2 . In sheet 1 , in column A , you put the e mail address to be compared,right ? If so, in B1 of sheet 1 , you type the formula ,

=IF(ISNA(A1=MATCH(A1,Sheet2!$A:$A,0)),"TO BE SENT","SENT") and pull it down , so that it gets copied to B2,B3,B4 and so on. The result , "TO BE SENT" OR "SENT" will be shown in column B.

Try this.

Regards,Manuel

 

[beividepabs]

Guys,

I cant believe it how helpful, I hope will be able to help people too one day!

MANY tahnks for your help all options provided work

Have a great Weekend

Regards
Pablo

Hello & Welcome to the Board,

Maybe try...

=IF(ISNUMBER(MATCH(I2,Sheet3!A:A,0)),"Sent","To be Sent")