How to use data validation for Mutiple lists dependant on one list

hi can any help me on this ......

i have three lists (suppose A,B & C ) in an excel sheet .... but i want when i select a value from list A .... corresponding values from list B & C ..should be appeared automatically automatically

i have attached a sample file ........ please suggest me any method

the required columns are C5 & D5 for B & C lists respectively

Check out..

thanks deepak ........ you solved my problem .......

can you sugesst me how to learn to use this vloopk up command

You can use excel help to learn VLOOKUP() or other excel functions. Press F1 to go to excel help and type the function name which you want to learn.

Thanks Deepak .......But one problem is arising .........

when i drag it down for other rows "# NA " error appears in other two columns .......so is there any way to remove that error .... i want to avoid it

so when there is nothing/no value in first column ....column b & C should also appear empty ......is it possible .........Help me with this (see attachment)

Use absolute references for your data range

fi in D5

=VLOOKUP(B5,$J$5:$L$9,3,0)

and for missing values

=IF(countif($J$5:$J$9,B5),VLOOKUP(B5,$J$5:$L$9,3,0),"")

still problem is there that NA# doesnt goes away ......................can any one please help me

If you use my second suggestion no NA should appear.
Please post your workbook showing the errors

I was assisted greatly in this thread to this very point. Did you search Data validation prior to posting?

http://www.excelforum.com/excel-gene...struction.html

thanks arhturbr ....