C
Col
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.
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.