Results 1 to 2 of 2

Thread: Help with autfilling columns

  1. #1

    Help with autfilling columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •