# VLookup on 3 Columns Formulae

#### midfieldgeneral11

##### Active Member

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.

Simon

### 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
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

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."

Replies
1
Views
44
Replies
4
Views
67
Replies
1
Views
37
Replies
3
Views
27
Replies
3
Views
48