Data Validation + vlookup

msohail

Board Regular
Joined
Oct 9, 2002
Messages
120
I have a list of staff groups and their pay points on the scale. I want to create a drop down list and when they select their staff group only the pay points relevant to their group shoud appear in the list.

At present my data is in two sheets. Sheet 1:
STAFFGRP
academic
clerical
manual

Sheet 2
STAFFGRP PAypoint
Academic 1-10
manual 11-20
clerical 21-30

How do i achive this please?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,685
Please explain ... when they select their staff group ... what from? A drop-down? Where ( i.e. cell ref please )?

You also say "only the pay points relevant to their group shoud appear in the list" ... errrm, is this a list in a drop-down somewhere ( where?) ? If this is about dependant drop-downs, have a look at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal02.html
 

msohail

Board Regular
Joined
Oct 9, 2002
Messages
120
Thanx Glenn, that ref was a treat and the site is so useful. cheers
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,501
Messages
5,832,088
Members
430,110
Latest member
Chyke_mxl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top