VLookup on 3 Columns Formulae

midfieldgeneral11

Active Member
Joined
Feb 11, 2004
Messages
460
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,348
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

Active Member
Joined
Feb 11, 2004
Messages
460
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."
 

Watch MrExcel Video

Forum statistics

Threads
1,108,519
Messages
5,523,356
Members
409,513
Latest member
TibiBenyi

This Week's Hot Topics

Top