Auto fill values based on drop down list

**Jahoobie** · 09-21-2010, 10:18 AM

I'm trying to figure out how to auto fill values of different cells based on which value I choose from a drop down list in Excel 2007.

I have the drop down list created, and the only way I could figure out to auto fill the values was to do =IF(A2=M2, "Value A", IF(A2=M3, "Value B", IF(A2=M4, "And so on...")))

Several things with this though, if I need to add additional items to the list, I'd have to go through each IF statement and add them, AND, will have multiple columns and rows that I will be tallying.

What's the "easy" way to do this?

**Richard Buttrey** · 09-21-2010, 10:30 AM

Hi,

It might be easier if we could see the workbook in question, but have you tried creating a table of the M2, M3, M4 etc values and alongside in N2, N3, N4 etc the Value A, Value B etc. values. Then use =VLOOKUP(A2,M2:N100,2,FALSE)

Better still create a dynamic range name for your range M2:N??, say 'MyTable' so that it will expand if you add values and use =VLOOKUP(A2,MyTable,2,FALSE)

HTH

**Jahoobie** · 09-21-2010, 11:04 AM

I uploaded a test xlsx to sort of show what I'm trying to do. I only have the first two if statements done...and you can see why I'm looking for an easier way.

I don't know much about VLOOKUP, but I will take a look into that, as well as creating the table and using that.