carry over data to other sheet - help needed

[Svea]

Dear excel specialists!

Please help me with problem I have. I would like to carry over data from one sheet to another but of course under special conditions.

Example: I have a table with many information about articles. On other sheet I have few positions for which I need only few information from the first sheet.
It's little difficult to explain, so I've added a excel table showing the problem and solution I used till now.

Thank you!

Regards,
Ines

[Max]

In inquiry,

Put in B2:
=INDEX(database!B:B,MATCH(A2,database!A:A,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Svea" wrote:
>
> Dear excel specialists!
>
> Please help me with problem I have. I would like to carry over data
> from one sheet to another but of course under special conditions.
>
> Example: I have a table with many information about articles. On other
> sheet I have few positions for which I need only few information from
> the first sheet.
> It's little difficult to explain, so I've added a excel table showing
> the problem and solution I used till now.
>
> Thank you!
>
> Regards,
> Ines
>
>
> +-------------------------------------------------------------------+
> |Filename: example.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=5033 |
> +-------------------------------------------------------------------+
>
> --
> Svea
> ------------------------------------------------------------------------
> Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
> View this thread: http://www.excelforum.com/showthread...hreadid=561442
>
>

[Svea]

Dear Max,

Thank you so much for your reply. I will use this formula in daily business and remember Max from Singapore Thanks again.

I have also visited savefile.com site and downloaded your examples. I think I will learn a lot from there. So happy!

Best regards,

Svea from Croatia (Europe)

[Max]

You're welcome, Svea! Appreciated your feedback.
We're quite global around here <g>
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Svea" wrote:
> Dear Max,
>
> Thank you so much for your reply. I will use this formula in daily
> business and remember Max from Singapore Thanks again.
>
> I have also visited savefile.com site and downloaded your examples. I
> think I will learn a lot from there. So happy!
>
> Best regards,
>
> Svea from Croatia (Europe)