[Ref2335]

I'm wondering if the Vlookup function can help with what I am attempting to do in Excel.

I'll try to explain what I want I need to have happen.
Cell A will contain a set value which the Vlookup will use as the row reference for the Vlookup.
Cell B will contain a value that represents a column on my reference value list, but it is variable and changes depending on what the initial value is in Cell A.
Cell C is where the final value is shown.

I have found, so far, a Vlookup will only tie on a 1-1 relationship. Can I get it to tie to a 1-many relationship, and how can I get it to do that? I'd prefer not to share the database as it contains very confidential information.

thanks!

[bomb #21]

I'm probably barking up the wrong tree but ... are you looking for a two-way lookup?

[Ref2335]

That looks like it!! I tried to use that and it seems really close. The problem I'm runing into is that its returning a value from an incorrect cell. I think we're on the right path, how do I get it to return the value from the correct cell?

[bomb #21]

Create a workbook with a small sample of your data and upload it -- we probably need to look at the cell B thing.

[Ref2335]

Here is a sample of what I'm working on. It seems it is pulling the value from sheet2 column C. Sorry to have to be cryptic on the data in the spreadsheet as its all confidential.

[bomb #21]

OK. I see that the combobox on Sheet1 is linked to B32 on Sheet2.

I don't follow the 2nd Choice/3rd Choice/4th Choice thing -- maybe you're thinking of adding more comboboxes later. (?)

But first, try these formulas in B12:E12 of Sheet1:

=INDEX(Sheet2!B$2:B$29,Sheet2!$B$32)

=INDEX(Sheet2!I$2:I$29,Sheet2!$B$32)

=INDEX(Sheet2!E$2:E$29,Sheet2!$B$32)

=INDEX(Sheet2!C$2:C$29,Sheet2!$B$32)

Are we close?

[Ref2335]

This is actually a spreadsheet that directs buyers where to look to buy parts. the 1st second 3rd etc are alternatives for the part that gets input by the drop down box. The cost field, the field I am having issues with(E12, E13, E14, E15), varies depending on the supplier which varies by where it falls in the heirachy.

B12:E12 are ok, they get populated by the dropdown. There should the same description in that field.

[bomb #21]

Sorry, I don't really follow. The cost field ... well, which are the cost fields on Sheet2? sm -- dl -- v -- OEM -- U?

Try this in E12:

=INDEX(Sheet2!$M$2:$Q$29,Sheet2!$B$32,MATCH(D12,Sheet2!$M$1:$Q$1,0))

& copy down to E15. Then if the dropdown is Tube1, the "costs" should be:

more -- not much -- Contact team -- lots

E12 ("more") is picked up from Sheet2!N2 because "dl" matches Sheet2!N1 in Sheet2!M1:Q1.
E13 ("not much") is picked up from Sheet2!M2 because "sm" matches Sheet2!M1 in Sheet2!M1:Q1.

And so on.

Is that any closer?

[Ref2335]

Not only is that closer, ITS SPOT ON! Thanks for the help!!!!!

[bomb #21]

I love it when a plan comes together (by accident ) -- enjoy.