V-Lookup question?

[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

 

[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

 

[Frank Kabel]

Hi
simply
=VLOOKUP(B10,lookup_range,index,0)

 

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

 

[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

 

[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

 

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

 

[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

 

[Linda]

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*