V-Lookup question?

K

Kim-Anh Tran

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
 
S

Simon Lloyd

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
 
B

Bob Phillips

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)
 
L

Linda

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
 
K

Kim-Anh Tran

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
 
B

Bob Phillips

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)
 
K

Kim-Anh Tran

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
 
Top