Find solution
How to dynamically fill empty space in a column?

Auto fill column B based on Column A Drop Down Selection in EXCEL?

  • in column A, i have a drop down selection : AUM 0k-50k 51k-150k 151k-300k 301k-500k 501k+ If i select one of these items, I want excel to auto fill column B with the appropriate "star" value AUM STARS 0k-50k 1 Stars 51k-150k 2 Stars 151k-300k 3 Stars 301k-500k 4 Stars 501k+ 5 Stars I think i should be using VLOOKUP but I cannot figure out how to enter it. Nothing I do is working. Please help!

  • Answer:

    Re: Your additional details: What IXL@XL is saying is to put your list of AUM entries down column X starting in cell X1 and then put your STARS entries down column Y, starting in cell Y1. If you use different columns for the AUM and STARS lists, just change the formula to match. For example, if your AUM and STARS are in columns J and K, make the formula: =VLOOKUP($A2, $J$1:$K$5, 2, FALSE) Hope this helps.

Jamie at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

If your dropdown list is generated by referring to a list somewhere on your sheet (not typed in the Source box directly) just add the star rating next to the list, then use VLOOKUP B2 =VLOOKUP($A2, $X$1:$Y$5, 2,FALSE) where X is AUM list and Y is STARS list

IXL@XL

If AUM is being compared against actual numbers (such that 68150 would earn 2 stars), you can use a slightly different VLOOKUP formula. Supposing you are putting a value in D1 and want the matching value in E1: E1 =VLOOKUP(D1, $A$2:$B$6, 2, TRUE) along with this table: A          B AUM     STARS 0          1 Star 51000   2 Stars 151000 3 Stars 301000 4 Stars 501000 5 Stars Notice how column A only has the starting values for each AUM category. If D1 has the levels (text like "0k-50k", not a number), then range_lookup in VLOOKUP should be FALSE, since it is comparing text, and you could use the table given in your example.

Nahum

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.