I have a drop down list in A1 and I want the value in A2 to change depending on which item I choose in the drop down list. The drop down list has items (apple, orange, grape) and I want the second cell to display the price of the item based on a list elsewhere on the spreadsheet.
If the list of items that can possibly appear in A1 is in C1:C3 and the prices are in D1:D3, B1 can be =VLOOKUP(A1,C1:D3,2,False)
use vlookup(lookup_value,table_array,col_index_num,range_lookup)...
thanks. =)
Hi is it possible to share the file for easy understanding.
It'd well appreciated.
Moin
Saintmoin,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks