Table : Sheet1

EMAIL NAME
[email protected] Adam
[email protected] David
[email protected] Mosses
[email protected] Issac
[email protected] Mary



Table : Sheet2

EMAIL NAME ALLOWANCE
[email protected] 100
[email protected] 170
[email protected] 300
[email protected] 430
[email protected] 700
[email protected] 100



Hi,

How should I put column NAME cell value in sheet2 after searching using sheet2 email address in sheet1 as indicator using EXCEL functions.

[email protected] was not listed in Sheet1 email address and I want to put a text value "Not Registered" in sheet2 column NAME cell value.


Thanks.

hi,

I'm not quite clear about your requirements/issue.
I don't think it can be showed "Not Registered" on Sheet2 if you search a certian content (the e-mail address) on Sheet1.You mean you will manually add the value "Not Registered" by coding ?It seems a little bit complicated.Anyway,I'm waiting for any possilbe solution.

regards

__________________________________________
I'm currently testing free managed XLS component,any recommendation?
Today is a gift. That's why it's called the Present!

Number Add by keyboard Alt + E + i + S