Hello everyone,
I have a quick question, I have 2 sheets with 2 tabels looking like this:
Table 1 - sheet1

Table 2 - sheet2

I want to somehow do the following:
Final table should look like this:

Any1 have any idea how to achive this?
Best regards and keep a good work!
I have a quick question, I have 2 sheets with 2 tabels looking like this:
Table 1 - sheet1

Table 2 - sheet2

I want to somehow do the following:
- Do all job in new sheet1
- From Table1 (A column) find match in Table2 (E column)
- Copy content from Table 2 (D column)
- Paste it in Table 1 column B
- For all cells value in Table1 that don't have a match in Table2 write down DNP in D column
Final table should look like this:

Any1 have any idea how to achive this?
Best regards and keep a good work!