Lookup

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

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
 
In B1 enter
=VLOOKUP($A1,'rates'!$A$1:$C$3,2,FALSE)

In B2 enter
=VLOOKUP($A1,'rates'!$A$1:$C$3,3,FALSE)
 
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:
 
Back
Top