Linked results

**m_k** · 12-09-2011, 10:48 AM

I have a big sheet with multiple columns and too much data.

Column A, B and C should be interlinked not like applying filter and getting results, maybe using data validation or something and also not by VBA.

Such that if i select something from column A then after B and then after C using data validation or combobox somewhere on the sheet, then accordingly results from other columns alongside those columns are printed.

**NBVC** · 12-09-2011, 11:49 AM

Try something like:

=INDEX(D$1:D$100,MATCH(1,INDEX(($A$1:$A$100=X1)*($B$1:$B$100=Y1)*($C$1:$C$100=Z1),0),0))

Where X1, Y1, Z1 are the respective dropdowns for items in A1:A100, B1:B100 and C1:C100. This will pull item from column D at same row. copy across to get column E, F, etc....

adjust ranges and references to suit.

**m_k** · 12-09-2011, 10:48 PM

Items in column A,b and C are not just X1,Y1 or Z1, there are 5 type of items in A,4-B and 7-C. Can we do it using a drop down?

Also it would be very helpful if you attach a dummy for explanation.