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?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,989
Members
412,633
Latest member
simon_elvin
Top