Taking info from one sheet & selecting from another.

[szm187]

Forgive me if my explination here is a bit odd... I'm not 100% how to even phrase this...

On Sheet (A), I have about 650 lines of information. About 8 columns worth. It's irrelevant what information it is, but it's either text or numbers. No formulas or what not. The first column has an identifier that is alphabetized.

On Sheet (B), what I would like to do is be able to do is select from a drop down box from the first column what is reflected in the (A) sheet, and then once I choose it from the drop down box, the remaining columns would fill themselves with the appropriate information.

Horrible visual representation...

Sheet (A)

Bob 1 3 5 7 Banana Orange
Tom 3 7 11 15 Apple Peach

Sheet (B)

(drop down box in column A)

****(+)

(I choose Bob from the drop down box, then the entire row reads as

Bob 1 3 5 7 Banana Orange

Thank you for any help you could provide.

[JBeaucaire]

I use INDEX/MATCH for this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions.

Here's some sample sheets showing what I think you're looking to do.

INDEX/MATCH Examples

INDEX/MATCH explanation
http://www.excelforum.com/excel-gene...ame-row.html#3

[szm187]

Meh, okay, me dumb. I've been pouring over this the last hour or so and I'm not very far from where I was...

So, when I'm entering the value, I get choosing the array of the values I want to choose, but the rest of it seems to be imploding, and when I'm looking at the example above (the index-match sample), the portion in the Main sheet that I want to look at where the drop down box formula came from just simply doesn't have it there. Don't think I'm telling you anything you don't already know, but I digress.

Anyway, I do have a copy of the mundane little database I have here in case that is more relevant. Basically, what I'm wanting to do is on the second sheet, be able to enter the name, then have the rest of the fields fill themselves in. I know this is FAR easier than what I'm making it out to be, but for whatever reason, it's beyond me today.

Not enough coffee I suppose.

[szm187]

So, I'm sifting through the explination link above and what not, and maybe this will explain where I'm lost...

(as listed in the post)

=INDEX(RangeToReturnAValueFrom,Match(Value,RangetoMatchValueTo,FALSE))

So, I believe I would (on the 2nd sheet) type in A1...

=INDEX(Sheet1!A3:Cardlist!A3:A668,Match(B1:L1,CardList!B:l3,FALSE))

Now, obviously, that isn't working, but why? I'm assuming the 2nd part where I list the RangetoMatchValue is off, but I have no idea what to replace it with as to where it will understand I want it to match whatever gets pulled in the drop down box. And I really don't know what the FALSE is referencing and whether or not that's appropriate for this.

[JBeaucaire]

Your formula is accidentally referencing two different sheets in the first parameter.

Here's your sheet back, I added a sheet1 to do the lookups from, looking up the data on your Card List sheet.

Notice the formula in B2:

=IF($A2="", "", INDEX('Card List'!B:B, MATCH($A2, 'Card List'!$A:$A, 0)))

This cell is copied down and across to get the rest of the data that matches the character selected in column A.

For the selection process, I added a drop down menu that is taking it's values from all the values in Card List column A.

[szm187]

Ah. Sometimes it's the simple levels of stupidity that hinder us... :-)

You sir, are a prince, much obliged.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.