Data Validation problem :(

[sonu1975]

Hi,

I am trying to get data validation to find all the names with a specific text which matches a certain text or a nr.

Example:

1. Sheet M: Lets say I have chosen a certain name from dropdown menu via data validation (column C) and on column E i want it should show only the list of thoses names which are connected to name in column B and C. So if it shows "DV" and "2650 F HHC" then I want data validation to show a list of only thoses names which only include text in column B & C. (Info in sheet B, column C)

Thanks !

[salim ali]

Try this macro

Please Login or Register  to view this content.

[sonu1975]

Can it be done without VBA ?

[salim ali]

Can it be done without VBA ?

May Be like this file

[kvsrinivasamurthy]

For DV E3:E38

=OFFSET(INDEX(B!$C$3:$C$16,MATCH(C3,B!$B$3:$B$16,0)),0,0,COUNTIF(B!$B$3:$B$16,C3))