• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with list and corresponding values

RanjanSatya

New Member
Hi All,

Request your help on the List which i am trying to make and the corresponding values.

I have a Table with dump and have created a corresponding list of projects.

Now when is select the values in the Project Cell J:2 i want the corresponding values to come up in Cell J3:J6.
Thank you
upload_2015-3-30_11-48-20.png
 

Attachments

  • New Project.xlsx
    11.3 KB · Views: 0
J3: =INDEX($C$3:$F$11,MATCH($J$2,$B$3:$B$11,0),ROWS($J$3:J3))
Copy down
This assume the Fields are in the same order as the data Area

or
J3: =INDEX($C$3:$F$11,MATCH($J$2,$B$3:$B$11,0),MATCH($I3,$C$2:$F$2,0))
Copy down
This allows the Fields to be in any order
 
Post testing i found one error..

If the Project name is similar it will not change the corresponding values.

Please let me know if we can fix this...

upload_2015-3-30_13-7-39.png
 

Attachments

  • New Project.xlsx
    9.4 KB · Views: 0
Hi Rajansatya - so what would you like to happen in this case..

1) Appear details of both side by side..
2) Appear details of 1st Item or the last item(in this case second item)
 
Hi Asheesh,

I want the values to display accordingly.

In this case i have updated 7 as duplicate... so if i am selecting the first 7 or the second 7 in the list it should display the values accordingly.

Hi Hui,

I found this issue when is tried to apply the formula on the actual dump that i have.
 
What does accordingly mean ?
Do you want the first or second ?

Can't you simply rename them to 7.1 & 7.2
 
Basically these are names and have different locations and values.

If we don't have a fix then only option is to rename them.

Please see if we can derive a formula either to take the values as selected or display both Side by Side
 
Asheesh,

This works... thanks
But not able to apply same formula on my dump

upload_2015-3-30_15-14-38.png

Seems like i am not able to get those highlighted brackets...
 
I have used a combo box which is a form control.
Now if you right click on the combox and then click on form control
In the next pop-up, you will see the Input range i.e. your projects

Now,

There is an index number assigned to the item that is selected in the combobox and that index number is populated in cell G1..then I use the formula to use this index number to look up for data

Go through the below links

http://best-excel-tutorial.com/57-vba-tutorial/178-combo-box

http://chandoo.org/wp/2011/03/30/form-controls/
 
Back
Top