Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
Hi,
I have a table below. A B C D 1 East Midlands 90% 20% 2 Midlands 40% 30% 3 Southern 20% 15% This table is on a worksheet called rates. I have another worksheet where I want a drop down box in cell A1 that the user can select either East midlands, Midlands or southern. When one of them is selected I would like cell B1 to show the first percentage for that area and cell B2 to show the second percentage. Hope someone can help and this makes sese |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
In B1 enter
=VLOOKUP($A1,'rates'!$A$1:$C$3,2,FALSE) In B2 enter =VLOOKUP($A1,'rates'!$A$1:$C$3,3,FALSE) "Glenn" wrote: Hi, I have a table below. A B C D 1 East Midlands 90% 20% 2 Midlands 40% 30% 3 Southern 20% 15% This table is on a worksheet called rates. I have another worksheet where I want a drop down box in cell A1 that the user can select either East midlands, Midlands or southern. When one of them is selected I would like cell B1 to show the first percentage for that area and cell B2 to show the second percentage. Hope someone can help and this makes sese |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
First name the range A1:A3, say "areas",then create Validation list with
source =areas, then enter formula =VLOOKUP($A1,Rates!$A:$C,COLUMN(),FALSE) in B1 of 2nd sheet and fill it to the right and down! Regards, Stefi €˛Glenn€¯ ezt Ć*rta: Hi, I have a table below. A B C D 1 East Midlands 90% 20% 2 Midlands 40% 30% 3 Southern 20% 15% This table is on a worksheet called rates. I have another worksheet where I want a drop down box in cell A1 that the user can select either East midlands, Midlands or southern. When one of them is selected I would like cell B1 to show the first percentage for that area and cell B2 to show the second percentage. Hope someone can help and this makes sese |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |