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