text in a list to equal many different values

Hi all,

I am new to this forum, I apologise if the title is incorrect in what iam askin for

1)My problem is i have a list in sheet 2 that have made into a list via data validation e.g column a has a supervisor (a1) apprenctice (a2) Trades assistant (a3)

i have made this into a list and named it labour.

what i need to figure out is when i data validate a cell with the Labour list, i want so when i pick supervisor it will return a predetermined (example below) value in another.

A B
supervisor 100
apprentice 80
Trades Assistant 70

(c3) (c4)
(list) Supervisor 100

I hope this clear

thanks in advance

hopefully this is what you want

I forgot to upload the file containing my approach to the question

this is a sample file

Example 1.xlsxHi thansk for the reply

Iam not explaining it very well i have attached the problem

Thanks again

add this code to cell c16

Please Login or Register  to view this content.

Thanks that is awesome

you are most welcome. please mark your post as solved