Hi all,
Don't know if this will test you or not.

I'm trying to combine a drop down list along with a lookup facility.

I have a list of job grades in say A2:A5 along with pay scales along the
columns - Min/Med/Max.
Whatever is input in a certain cell somewhere else on the same sheet for
example further down in column A 'Manager Grade 1', I would like the lookup
to default to the Max value in the corresponding cell in column B but leave
the cell unprotected so the user can enter the correct value.

To aid the user further I would like a dropdown box to show the correct
values.

I've tried using the standard dropdown and data validation but so far to no
avail.

Help anyone?

Thank you,

Colin.