Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP HELP PLEASE
I have been able to create a drop down list, but cant work out how to create
a vlookup to auto fill in the price associated with an item. CELL A1 - DROP DOWN LIST ITEM CELL A4 - AUTO FILL PRICE FOR THIS ITEM I would keep the lists for both items and prices in a seperate sheet, but not sure if they must be next to each other, A1 & A2 for example. Any help would be good Thanks |
#2
|
|||
|
|||
They don't have to be next to each other, certainly not row wise, but they
might just as well be so. The important thing for VLOOKUP is to put the lookup value, item in your example, in the first column. As an example, sheet2 A B 1 Item1 26.00 2 Item2 37.34 3 Item3 22.44 etc. Then on the sheet1, assuming the dropdown is in A1, in say A2, add =VLOOKUP(A1,Sheet2!A1:B100,2,False) -- HTH Bob Phillips "Julian Campbell" wrote in message ... I have been able to create a drop down list, but cant work out how to create a vlookup to auto fill in the price associated with an item. CELL A1 - DROP DOWN LIST ITEM CELL A4 - AUTO FILL PRICE FOR THIS ITEM I would keep the lists for both items and prices in a seperate sheet, but not sure if they must be next to each other, A1 & A2 for example. Any help would be good Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup with validation | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |