Return matching data from another sheet

[ch1981]

I am looking for help on how to Use VLOOKUP Across Multiple Worksheets.

I have a sheet with data on it, so part numbers in a column a, description in b column, picking location in c column, and supplier in d column.
Then on a different sheet i want to be able to write the part number in columb B, and the other info automatically update. so description in column c, picking loc in column d, supplier in column e.
how is this done?

Thanks in advance

[FDibbins]

1. You really need to use titles that describe what your problem is, not what you thing the answer might be (I will adjust your title for you - this time )

2. In this case, vlookup is probably the way to go, and can be used across sheets or even across files. So, maybe something like...
(Due to lack of a sample file, Im guessing here)
data sheet

	A	B	C	D
1	PN	Desc	Loc	ID
2	123	aaa	a1	890
3	124	bbb	a2	891
4	125	ccc	a3	892
5	126	ddd	a4	893
6	127	aaa	a5	894
7	128	bbb	a6	895
8	129	ccc	a7	896
9	130	ddd	a8	897

Extract sheet

	A	B	C	D
1	PN	Desc	Loc	ID
2	124	bbb	bbb	bbb

A2 would contain the PN you want
B2=VLOOKUP(Sheet2!$A2,Sheet1!$A$2:$D$9,2,0)
copied across as needed

[TMS]

Something like

Please Login or Register  to view this content.

dragged across and down.