Help with VLOOKUP formula

[www2]

I'll try to explain this as simple as possible:

I have attached a combo box, and in it I have the option to select three materials. Each material has its own characteristics (strength, hardness and density).

Now, I' want to choose one of these three materials and by choosing one I want his properties to automaticlly fill in particular CELL's.

To be clear here is a picture:3

http://img.photobucket.com/albums/v5...board01-19.jpg

....... So in the three bordered cells I would like to automatically see the material properties of P235 .... 100-120-150

Thank you


EDIT: the words are Croatian and the meanings are : Čvrstoća-strenght; tvrdoća-hardness; gustoća-density

[zbor]

Hi www2, wellcome to the forum...

Please, rename your title according to the rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

Also, please upload excel file rather then picture.

Ajde, riješi to pa ćemo ti pomoć

[TMS]

You need to change your thread title to something more meaningful in order to comply with the forum rules.

If you do not do this, it is unlikely that you will get a response.

I would suggest you call it something like "Help with VLOOKUP formula" ... which may give you a clue to the probable answers.

Posting a sample workbook will also help to ensure you get a quick and accurate response.

Regards

[zbor]

Nah, Help with VLOOKUP formula would also implify that post title describing anticipated solution, and not the problem.

Who know what formula(s) will be used

I wopuld rather call it as: How to take values from the table for desired criteria.

[TMS]

@zbor: fair comment ;-) It also occurred to me that if the OP new what to call the thread, s/he would know the answer ... but couldn't think of a generic and appropriate title. Thanks

[www2]

OK

Sorry for not reading the rules guys.....post title changed accordingly.

I have made an example sheet for your better understanding.......What I want is next.....


When I choose lets say material P195GH I would like to automatically fill those three bordered cells to fill with its properties 195....175....320-400

[TMS]

@zbor: you were right ;-)

@www2: OK, not necessarily a VLOOKUP.

Change the properties of the List Box to add a Cell Link = $C$2.

Then, in cell B8, put the formula: =INDEX(L$12:L$26,$C$2)

Drag this across to the next two cells.

The merged cells in the table will give you a problem though as only the first entry in a "Block" will have a value assigned to it. For example, P275NL2; EN 102016-3 (third block, second entry) will return all zeros. You need to remove the merged cells and replicate the values ... not as pretty but the only way to make this work.

You don't really need a List Box; you could use Data Validation and then you *could* use VLOOKUP. But that's another question.

Regards

[www2]

Thank you for your reply.....I cant put this formula as I get an error

This is what I get

[zbor]

Replace , with ; (due to regional settings)

[www2]

Thank you guys a lot........this saved my life

Drinks are on me

[zbor]

Pazi što si obećao da se ne pojavim na piću :P

[TMS]

You're welcome ... and whatever zbor said ;-)

Please mark your thread as solved. See my signature for details.