Vlookup with Multiple Conditions

[Yugo101]

Hey Everyone,

Wondering if can help.

I have 2 spreadsheets. One is customer information (Main Sheet) and other is more in depth customer info sheet (Sheet 2).

Basically i have a formula which does work but doesn't take into consideration that there could be duplicate names, at the moment it seems to only take the first name it finds and retrieves that text.

Here is my current formula - (hopefully its correct i typed it up because its form work computer.

=if(vlookup((A1,'[20212012 2nd sheet.xlsx]2nd sheet'!$C:$C,1,False)=A1,(Vlookup(A1,'[20212012 2nd sheet.xlsx]2nd sheet'!$C$2:T:658,16,False)))

Main Sheet -
A: Customer Name
b: ref ( I want to use)
2nd sheet
C: Customer Name
d: ref.

So currently it matches Name from Main sheet to 2nd sheet and retrieves certain info, but because of the duplicate names it brings the first one back for multiple results.

How can introduce another function so match name and another column so it 100% accurate in matching on 2nd sheet.

Sorry if confusing, be easier if the sheet was confidential.

Thanks

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Alex Blakenburg]

Assuming you want it to work on a closed workbook you could give this a try:-

=IF(ISERROR(LOOKUP(2,1/(('[20212012 2nd sheet.xlsx]2nd sheet'!$C$1:$C$10000=A1)*('[20212012 2nd sheet.xlsx]2nd sheet'!$D$1:$D$10000=B1)),'2[20212012 2nd sheet.xlsx]nd sheet'!$R$1:$R$10000)),
           "Not Found",
            LOOKUP(2,1/(('[20212012 2nd sheet.xlsx]2nd sheet'!$C$1:$C$10000=A1)*('[20212012 2nd sheet.xlsx]2nd sheet'!$D$1:$D$10000=B1)),'2[20212012 2nd sheet.xlsx]nd sheet'!$R$1:$R$10000))