Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
Cell B10 contains a drop down list. Is it possible to do v-looku
reading from the drop down list? I would like to assign a value in cel A10 and this value depends on what appears in cell B10. I tried it bu it does not work! I appreciate any help! Regards, Kim-An -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
Hi,
Can you supply the code you were using...if you created a dropdown lis using data validation you will have allowed a list rom anothe sheet...so you already have a lookup list so if you use the matc scenario it can match the value in B10 with the lookup list you used i data validation and you would use this code in the worksheet shee selection change or if its for the whole workbook on the the workboo sheet selection change....i think...if i have it right! Simo -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
Hi
simply =VLOOKUP(B10,lookup_range,index,0) -- Regards Frank Kabel Frankfurt, Germany Cell B10 contains a drop down list. Is it possible to do v-lookup reading from the drop down list? I would like to assign a value in cell A10 and this value depends on what appears in cell B10. I tried it but it does not work! I appreciate any help! Regards, Kim-Anh --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
Kim-Anh,
Did you try something like =VLOOKUP(B10,F1:G3,2,FALSE) in A10, because it works for me? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kim-Anh Tran " wrote in message ... Cell B10 contains a drop down list. Is it possible to do v-lookup reading from the drop down list? I would like to assign a value in cell A10 and this value depends on what appears in cell B10. I tried it but it does not work! I appreciate any help! Regards, Kim-Anh --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
If your drop down list is coming from "Data Validation",
you could produce your list (in Column A) on another sheet (Sheet1) and set it up as a table. The value in the next column (Column B) would be the one you want assigned when the item is picked from the list. Add a "Vlookup" formula in cell B10 that you want populated with the data from the second column. For example: A B 1 Apple 10 2 Pear 7 3 Peach 6 4 Orange 8 Give the list in column A a "Name" (Insert, Name, Define). When you set your data validation on cell B10, paste the list name into the list box. Write your Vlookup formula in Cell A10 (=vlookup(B10,Sheet1! $A$1:$B$4,2,false). Hope this helps. I'm sure there are other ideas out there, too. Linda -----Original Message----- Cell B10 contains a drop down list. Is it possible to do v-lookup reading from the drop down list? I would like to assign a value in cell A10 and this value depends on what appears in cell B10. I tried it but it does not work! I appreciate any help! Regards, Kim-Anh --- Message posted from http://www.ExcelForum.com/ . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
My appreciation to Bob and Frank!
Drop down list is in Sheet 1, B10. Range is B1:C6. My formulas is: +VLOOKUP('Sheet1'!B10, B1:C6,2). Could the problem b because I use same code o1 for House, Condo, and Town House? *B1* *C6* 01 House 01 Condo 01 Town House 02 Apartment 03 Mobil Home 04 Motel Regards, Kim-An -- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
Most definitely, VLOOKUP wants a unique lookup value otherwise it just
returns the first value found. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kim-Anh Tran " wrote in message ... My appreciation to Bob and Frank! Drop down list is in Sheet 1, B10. Range is B1:C6. My formulas is: +VLOOKUP('Sheet1'!B10, B1:C6,2). Could the problem be because I use same code o1 for House, Condo, and Town House? *B1* *C6* 01 House 01 Condo 01 Town House 02 Apartment 03 Mobil Home 04 Motel Regards, Kim-Anh --- Message posted from http://www.ExcelForum.com/ |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
Thanks to Simmon and Linda, too!
Hello everyone, This is my formulas. All I got is the formulas shows in cell C6 as type in even though cell B39 list Independent. =VLOOKUP('Assmt Front'!B39,Tables!D8:E12,2) *Range is D8:E12 in sheet name Tables.* 01 INDEPENDENT 02 SHARED 03 LIVE-IN PROVIDER 04 LANDLORD/TENANT 05 ROOM & BOARD Drop down validation list is on cell B39 in sheet name Assmt Front an my look formulas is in sheet name 293 cell C6. Did I do somthing wrong? Regards, Kim-An -- Message posted from http://www.ExcelForum.com |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
V-Lookup question?
You need to reverse the columns in your lookup table.
The data being looked up needs to be the the left most column of your lookup range. Then the data you wanting as a result is in column 2 (the 2 in your formula). So just switch your table to *B1* *C6* House 01 Condo 01 Town House 01 Apartment 02 Mobil Home 03 Motel 04 -----Original Message----- My appreciation to Bob and Frank! Drop down list is in Sheet 1, B10. Range is B1:C6. My formulas is: +VLOOKUP('Sheet1'!B10, B1:C6,2). Could the problem be because I use same code o1 for House, Condo, and Town House? *B1* *C6* 01 House 01 Condo 01 Town House 02 Apartment 03 Mobil Home 04 Motel Regards, Kim-Anh --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Question | Excel Discussion (Misc queries) | |||
LOOKUP Question [again!] | Excel Discussion (Misc queries) | |||
LOOKUP Question | Excel Discussion (Misc queries) | |||
Lookup question | Excel Discussion (Misc queries) | |||
lookup question | Excel Worksheet Functions |