Mix data from another excel

[Bendt Skov]

In Emner.xlsx, the name can occur, and if it does with this formula = IF (COUNT IF ([Investors.xlsx] Sheet1! $ A $ 2: $ A $ 10; 'Sheet1'! $ A1); "Exist"; "NEW ")
then it says Exist.
If there is also a number in B in Emner.xlsx, this number should be written, if nothing else it is empty.
What formula do I need to get that number from the same row as the name in the other sheet?
It does not matter that the number also comes with the rows where it says New, but it is not needed

File "investors" has this:
Andersen 0
Petersen 10
Jensen 20
Nielsen 30
Skov 30
Hansen 40

file "emner" should show:
Hansen Exist 40
Skov Exist 30
Nielsen Exist 30
Peter New
Niels New
Børge New

[AliGW]

Please update your forum profile with your current version of Office.

Please provide a composite sample workbook with data on different tabs representing the different workbooks.

[Richard Buttrey]

Hi and welcome to the forum

B1: =IF(ISERROR(MATCH(A1,[Investorer.xlsx]Ark1!$A:$A,FALSE)),"New","Exist")
C1: =IF(B1="Exist",INDEX([Investorer.xlsx]Ark1!$B:$B,MATCH(A1,[Investorer.xlsx]Ark1!$A:$A,FALSE),1),"")

both copied down as necessary

[Bendt Skov]

Thanks for trying to learn me, but I did not get it working.
Can you put the solution into the file emner.xlsx and get the wished figures E1=40, E2=30, E3=30 and nothing in E4, E5 and E6 ??
/Bendt

[Bendt Skov]

Sorry, forgot to update - Done

[Bendt Skov]

Thanks a lot for your help

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Richard Buttrey]

Thanks for trying to learn me, but I did not get it working.

/Bendt

It may be that English is not your first language so please accept this comment in the helpful way it's intended.

We don't say someone is trying to 'learn' someone, we use the word 'teach'. Learning is something you receive, teaching is something you give.