j8zel

Junior Member

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation - drop down list	Oscar	Charts and Charting in Excel	0	February 18th 10 10:28 AM
Data Validation with Drop-down list	Ulrik Loves Horses[_2_]	Excel Worksheet Functions	2	October 22nd 08 11:08 AM
DROP DOWN LIST DOES NOT APPEAR USING DATA VALIDATION	SEAN DI''''ANNO	Excel Discussion (Misc queries)	0	November 27th 07 05:38 PM
Drop down list in Data Validation	Big Rick	Excel Discussion (Misc queries)	3	October 4th 05 04:49 PM
Data Validation using List (But needs unique list in drop down lis	Tan	New Users to Excel	1	July 8th 05 03:32 PM

All times are GMT +1. The time now is 02:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us