Help with autfilling columns

[mawngr]

Hi, wondering if anyone can help me with this. I am trying to set up an excel spread sheet and wondering if i can set it up so that when i enter a value a specified value appears in a corresponding cell
e.g
when i type Blue in A1 the number 2363 automatically fills into cell C1.
Red in A2 number 4521 automatically fills into cell C2

Not sure if I am explaining myself

Thanks for any help you can offer

[NBVC]

You can use an nested IF function or lookup function if there are a few, or better to use a Lookup table and then the VLOOKUP function.

e.g

If you have a list in X1:Z10 of the colours and corresponding values,

Then in C1 you would use a formula like:

=VLOOKUP(A1,$X$1:$Y$10,2,0)

copied down.

This will look for the A1 value in X1:X10 and return the corresponding value from Y1:Y10 in C1.