How to search specific list in different sheet

[aiezzat]

Hi all,
I'm a new member for this forum. The question is: How do i create a lin
between a sheet? My idea is, i need to type some specific text in a cel
(such as part no), and then excel will automatically shows the detail
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.

 

[Spencer101]

Hi all,
I'm a new member for this forum. The question is: How do i create a lin
between a sheet? My idea is, i need to type some specific text in a cel
(such as part no), and then excel will automatically shows the detail
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

 

[Don Guillett]

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..

Or use data>filter>autofilter macro