Get record from another sheet when value selected from dropdown-CodePudding

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

CodePudding user response：

I guess that in your "Product" sheet it will not be duplicated a Vlookup works. For instance ABC remains 440 as rate? Then you can have your "quantity" x "rate" to get your amount. What have your tried in Vlookup and what error?

CodePudding user response：

Try this in Orders sheet cell D2 =VLOOKUP($B$2,Product!$B:$C,2,FALSE)