How to get multiple values when using only a single cell reference in a formula.

Hi

Iam trying to do a excel worksheet for ordering parts. Usually the parts are ordered in a pagages which are defined by the car model. So when choosing a car model, the formula would find all the parts related to it and show them in different cells. I put excel worksheet with this post that everybody could understand that. Thanks!

Leugu,

You may put this code in the cell A9..

Please Login or Register  to view this content.

This is an array formula so put CTRL+SHIFT +ENTER after you have entered the code..

Hope this helps and for more information on this concept try searching for "MULTIPLE LOOKUP"..

Regards
E

Thanks, that solves the problem, but there is one problem, when i want to look at bmw parts and there is less parts than in toyota, it gives #NUM! to the empty cells, how can i get rid off that?

Leugu,

You can count the entries of BMW or Toyato and blank out the remaining entries..

Please Login or Register  to view this content.

Hope this helps..!

Please Login or Register  to view this content.

To blank out the entries..!


E4excel