I am using Excel 2007
I have two sheets. 1) Orders And 2) Products
Orders :
A B C D E
Sr No particulars quantity rate amount
-----------------------------------------------------------------
1 Dropdown from
Products B2:B50
------------------------------------------------------------------
2 Dropdown from
Products B2:B50
------------------------------------------------------------------
....... And So On.....
Products :
A B C
---------------------------------------------
Sr No ProductName Rate
---------------------------------------------
1 ABC 440
2 DEF 210
3 XYZ 185
...... And SO On...
In Orders Sheet, In Particulars, Dropdown box is generated with productnames in Products Sheet with Data Validation.
I want to autofill Rate of Product Selected from dropdown in Orders sheet
I tried VLOOKUP... But without success
Bookmarks