VLookup on 3 Columns Formulae

[midfieldgeneral11]

Good Morning Thanks for Reading

I have two spreadsheets one called Switch Info and the other Database Master, I am looking from the Database Manager to the Switch Info

Both Have three columns called Login (Column A), Device (Column B) and Numbers (Column C)

First Formulae

I need a lookup to be placed in Database Manager in Column D which takes column A, B and C and looks up on the Switch info for column A, B and C.

Where they match is to say MATCH in Column D

Second Formuale

I would like also a further formula like above but for this time to bring back details in Column C from the Switch Info

I have lots of these spreadsheets and would like your help on the formula to get cracking with this exercise.

Hope that make sense.

Thanks for your help.

Simon

 

[Special-K99]

1." I have two spreadsheets one called Switch Info and the other Database Master, I am looking from the Database Manager to the Switch Info

So what's it really called, Databse Master or Database Manager?

2. "I would like also a further formula like above but for this time to bring back details in Column C from the Switch Info"

But you know what's in column C already, it's part of the value you're using to lookup, ie it's the value in column C of Database Manager.
You've said it here

"I need a lookup to be placed in Database Manager in Column D which takes column A, B and C and looks up on the Switch info for column A, B and C."

 

[midfieldgeneral11]

Thanks for your question.

1." I have two spreadsheets one called Switch Info and the other Database Master, I am looking from the Database Manager to the Switch Info

So what's it really called, Database Master or Database Manager?
That was a spelling mistake. Corrected.

2. "I would like also a further formula like above but for this time to bring back details in Column C from the Switch Info"

But you know what's in column C already, it's part of the value you're using to lookup, ie it's the value in column C of Database Manager.
You've said it here

Yes you are right but I need the data brought back as I then need to review any differences and make a decision on which one is correct. They should be all a match. This is an Audit exercise.

"I need a lookup to be placed in Database Manager in Column D which takes column A, B and C and looks up on the Switch info for column A, B and C."