How to search specific list in different sheet
 

Hi all,
I'm a new member for this forum. The question is: How do i create a link between a sheet? My idea is, i need to type some specific text in a cell (such as part no), and then excel will automatically shows the details of this part(such as size,material,price,supplier and etc.) along a row. Of course i already key in all the part details in a different sheet. Thanks in advance..

Hi,

Search the internet or Excel's 'Help' for how to use VLOOKUP.

That will help you out.

How to search specific list in different sheet
 

On Thursday, September 27, 2012 3:52:19 AM UTC-5, aiezzat wrote:
Hi all,

I'm a new member for this forum. The question is: How do i create a link

between a sheet? My idea is, i need to type some specific text in a cell

(such as part no), and then excel will automatically shows the details

of this part(such as size,material,price,supplier and etc.) along a row.

Of course i already key in all the part details in a different sheet.

Thanks in advance..









--

aiezzat

Or use datafilterautofilter macro