Quote:
Originally Posted by bala_vb
yes, you are on the right track. Data validation and vlookup fetches the data as per your requirement.
refer to attached sheet, i made some sample data for you.
all the best
|
Thanks for replying back. Your spreadsheet is exactly what I want. I don't know how you did it. Will you be able to show me a step by step guide. I got the drop down list through validation however I don't know how to use Vlookup. Your work is appreciated. Thanks