Excel vlookup problems 2

[Jyggalag]

Dear all,

Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems

I currently have three files, file (1):

File 2:

And file 3:

Currently, file 3 has the name of all the accountants in column U. What I would like is for column U to have the name of the accountant removed, if the corresponding firm to that accountant in column D does not appear as a firm in column D in file 1.

How would I go about this? I would truly appreciate some assistance here!

Thank you so very much everybody, I cannot express how much I would appreciate your assistance in this matter!

Kind regards,
Jyggalag

 

[steve the fish]

You couldnt unless you use either a helper column to provide the answers, a table elsewhere of the client/accountant names or you use code.

 

[Jyggalag]

You couldnt unless you use either a helper column to provide the answers, a table elsewhere of the client/accountant names or you use code.

How would I do that? Any suggestion would be appreciated!

 

[steve the fish]

For example in V2 of file 3:

=IF(ISNUMBER(MATCH(D2,'[File One.xlsx]Sheet1'!$D:$D,0)),U2,"")

 

[Jyggalag]

For example in V2 of file 3:

=IF(ISNUMBER(MATCH(D2,'[File One.xlsx]Sheet1'!$D:$D,0)),U2,"")

Steve the fish you're a genius!

I solved it through your method and formula.

Thank you so much!!!

Have a wonderful monday :D

BR.
Jyggalag