Transferring differences between two databases / How do you do logical test an IF function for a range of values?

[Ogniani]

Hello, I am new here and I tried to find an answer but I couldn't, so I allow to ask the following two things:

1. How do you do logical test an IF function for a range of values?
Is it possible with IF (or another function other than VLOOKUP) to transfer the information from column A (Note) of Table 1 to column G (Note) of table 2, as the unique number for both of them are Requirement.
The condition is that the Requirement number may not exist in one or the other table, so I imagine that if I use =IF(H3=E3:E13,A3:A13,"") but selecting an entire column for "logical test" or "value is true", it does not work.

2. Detecting and transferring differences between two databases
Again, if we have two tables, in Table 1 on a daily basis the data are updated (the unique value is column E, Requirement) - sometimes, some values disappear, ie. they do not pile up one after the other
The database is in table 2 and we want to add only the new unique values (without removing the dropped ones)
Is there a function that allows us to add new values (records)?

I am aware that through VLOOKUP we can achieve the result, but given the large database and its different arrangement (of columns) will require preliminary operations from colleagues who do not work with Excel, so I'm looking for a simpler option so as to create a template in to work.

Thank you in advance

 

[jasonb75]

The database is in table 2 and we want to add only the new unique values (without removing the dropped ones)
Is there a function that allows us to add new values (records)?

Such things can not be done with formulas. If the data source is going to be changed or deleted and you want to keep a copy of the original data for reference then you will need to use more advanced methods, vba for example.

In regard to the first part of your question, vlookup is the simplest way to do what you want. Trying to achieve similar with logical arrays is a recipe for disaster.

 

[Ogniani]

Such things can not be done with formulas. If the data source is going to be changed or deleted and you want to keep a copy of the original data for reference then you will need to use more advanced methods, vba for example.

In regard to the first part of your question, vlookup is the simplest way to do what you want. Trying to achieve similar with logical arrays is a recipe for disaster.

Thank you, I just hoped there were functions I wasn't familiar with and learned them, but I was afraid of a similar outcome.

Thanks again for the prompt response.