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
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.
Bookmarks