Using list or macros to input predetermined values

  • Thread starter Thread starter Simmo86
  • Start date Start date
S

Simmo86

Hi, I'm not too familiar with the use of macros, and I'm not sure I need to
use them in this case. However, I am looking to essentially create a single
list that inputs values across a range of cells (across columns). For
example, consider a table of values:

A 1 13
B 5 10
C 2 7

I would like to create a spreadsheet containing a cell with a list, where I
can select the row A,B or C - and the adjacent values will automatically be
entered. (ie. select B from a list, and 5 10 appear (calling from a
preconstructed table).

I'm sure there are a number of ways, which is the simplest? Cheers.
 
Thanks, but that method requires several lists for each column. I probably
didn't do a very good job describing my objective. I'm hoping to just be able
to select one category from a list, which then outputs corresponding values
in the adjacent columns. For example, I want to select the type of shape from
a list, and the number of corners and lines will appear in the adjacent
columns - I select triangle in A1, 3 and 3 appear in B1 and C1 respectively.
 
Suppose you have the data in the range A1:C10. Suppose you create the list in
ColD..and in D1 you select the first entry. Use the below formulas in E1 and
F1 to populate the other data.

D1 = A
E1 =VLOOKUP($D1,$A$1:$C$10,2)
F1 =VLOOKUP($D1,$A$1:$C$10,3)
 
Thanks Jacob! I've almost got it working. The only problem I'm experiencing
now, is that the categories in the list begin with a number which I think is
confusing the VLOOKUP function. Is this possible? I noticed if I changed the
categories to start with letters it would work, but this is not acceptable in
this case. Is there anyway around this?
 
Use FALSE as the last argument. This is a logical value that specifies
whether you want VLOOKUP to find an exact match or an approximate match. If
FALSE, VLOOKUP will only find an exact match

E1 =VLOOKUP($D1,$A$1:$C$10,2,FALSE)
F1 =VLOOKUP($D1,$A$1:$C$10,3,FALSE)


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to store values in excel using macro ? 4
Data Validation List (conditional) 2
Weighted randbetween text list 3
Scrabble Value calculation for Welsh words 0
Macro to find the value of adjacent cell from a range of values 2
modified pivot table using a macro 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
VBA - Run same logic on values in columns 2 & 3 0

Back
Top