Latest Lists

how to make a template delivery report using excel where when i click the dropdownlist item the price appears?

Im using microsoft excel to make a template for our delivery reports. i used a drop down list for the items and what i want to do now is that when i choose an item, its corresponding price should appear in the cell beside it. how do i do that?

Public Comments

1. help
2. If your item list is in A1:A100 Your price list is in B1:B100 Your drop down list is in C1 This will look up the price for the item selected in C1: =INDEX(B1:B100,MATCH(C1,A1:A100,0))