CODEWITHSUNDEEP
excelms-accessvba
user1680431
user1680431

Reputation: 1

Excel Function of looking for the same same email address and compare the value of another corresponding cell

i have two sets of worksheets of registration details, names, email, date data is changeed etc.

i want to find if the email address in worksheet A appears in worksheet B and if there is, compare the value of date data is changed in both worksheets and if there is a different, either display a text or conditional formatting.

I'm looking at MS Access with SQL but does not seems to get the result that i want

Upvotes: 0

Views: 103

Answers (2)

SeanC
SeanC

Reputation: 15923

for comparing worksheets, VLOOKUP is the function you are going to be using.

the formula would look something like this:
=VLOOKUP(emailToFind,RangeThatHasEmailAndDate,ColumnOfInfoToReturn,False) (false=exact match)

So, with a table that looks like this:

Emails                  Dates
[email protected]     1-Jan
[email protected]    3-Jan
[email protected]    7-Jan
[email protected]    2-Jan
[email protected]    1-Feb

then the formula =VLOOKUP(A2,[Book2]Sheet1!$A$2:$B$6,2,FALSE) in C1 would get the date from the other sheet

Upvotes: 1

zen
zen

Reputation: 122

I do not know the exact syntax of Access, it a long time I worked with it, but general SQL is

data = SELECT set1.v1, set2.v1, ... FROM set1 join set2 ON set1.email=set2.email;
for item in data
    if item.value[0] == item.value[1]
          do something
    endif
endfor

It is just pseudo-code, maybe it helps ... if you post, what you tried, I probably remember the syntax and can help more in detail

Upvotes: 0

Related Questions