Assuming your inventory sheet is in Sheet2, and is identical in structure to
Sheet1, with data from row2 down

In Sheet1
------------
Item will be keyed into I6:I16

Put in B6:
=IF(ISNA(MATCH($I6,Sheet2!$I:$I,0)),"",INDEX(Sheet 2!B:B,MATCH($I6,Sheet2!$I:
$I,0)))
Copy B6 across to D6, fill down D16

Put in K6
=IF(ISNA(MATCH($I6,Sheet2!$I:$I,0)),"",INDEX(Sheet 2!K:K,MATCH($I6,Sheet2!$I:
$I,0)))
Copy K6 down to K16

(Items are assumed unique in the inventory sheet)

A sample file is available at:
http://www.savefile.com/files/3429148
File: Cen_misc.xls
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"CEN" wrote in message
...

B C D I
K
1 Twine TW-4357 049830A 2BRT3 5820-01-410-8981
2 AC HK-4723 5788125 1dep 6234-00-257-9831
3 AC HK-4723 578126 2dep 6234-00-257-9831
4 AC HK-4723 578995 3dep 6234-00-257-9831
5 AC HK-4723 578414 4dep 6234-00-257-9831

It looks like this, while some items are the same but have different
serial numbers. On the second page I have a complete list of all the
items (about 200 or so) but only use about 16 lines at any one time on
this sheet. I want to type in the info from box I and have the other
information (which is on the second page) put in.
So far this is some great responses and quick too. :)
I will have to try it out this friday when my schedule lets up a
little. Thanks all!


--
CEN
------------------------------------------------------------------------
CEN's Profile:
http://www.excelforum.com/member.php...o&userid=25215
View this thread: http://www.excelforum.com/showthread...hreadid=387048