VLookup help - to get a value when 3 item match 3 on another sheet

[joeydeacan]

Good morning,

I have been trying this all morning and can get it to work.

On the first sheet I have set three drop downs from columns on sheet 2.

I want to display coloumn 6 from the second sheet when all these three match, but it wont work !

I have done this

=VLOOKUP(B7&C7&D7,Labels.!C5:E35,6,0)

Please can someone tell me what im doing wrong to save my sanity !!!

Thanks
Ben

[AliGW]

=VLOOKUP(B7&C7&D7,Labels.!C5:E35,6,0)

There are not six columns in the lookup table (C, D, E = 3).

B7&C7&D7 needs to match something in column C of the lookup table - does it?

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[joeydeacan]

So sorry i think I have misunderstood v lookup completely.

I have attached my sheet, as you can see I have created 3 dropdown on sheet1 from the data on sheet2.

I wanted to display column 6 from sheet 2 when these 3 dropdowns are populated.

I hope im making some sense !

Ben

[JohnTopley]

Try

=IFERROR(INDEX(Labels!$F$5:$F$50,MATCH(B7&C7&D7,Labels!$D$5:$D$50&Labels!$C$5:$C$50&Labels!$E$5:$E$50,0)),"")

Enter with Ctrl+Shift+Enter

I removed full stop from "Labels" tab

Or

=IFERROR(INDEX(Labels!$F$5:$F$50,AGGREGATE(15,6,ROW($A$1:$A$50)/(Labels!$D$5:$D$50=$B7)/(Labels!$C$5:$C$50=$C7)/(Labels!$E$5:$E$50=$D7),ROWS($1:1))),"")

Normal entry