Extracting rows from a large price list

[Dana20000]

Hi, I have a suppliers price list with over a thousand rows, I want to extract around 300 rows that are relevant to my business. The supplier price list has unique 6 digit number for each row in colum A. I have a list of those unique numbers, can I use it to help me extract the rows I want on a new spreadsheet rather than me going through the original price list manually deleting the rows I don't want?
thanks

 

[Fluff]

Hi & welcome to MrExcel.
A few questions.
1) Where is the price list, Sheet name & range?
2) Where is the list of numbers?
3) Where do you want to extract the data to?

 

[Dana20000]

Thanks for the welcome, Sorry left a lot out, Suppliers price list is in excel column A has list of unique codes, column B has item description, column C has strength of product, column D has pack size and column G has price, data is contained in rows 5 to 1841 inclusive. I have a separate spreadsheet with the same in columns A, B, C & D and are the products I stock at the moment 300 rows 2 to 302 inclusive (may vary month to month), what I need to do is extract these from the suppliers spreadsheet with the prices, essentially making the price list customised to my inventory. Hope I've explained myself okay? Good luck with the rugby Fluff, big Wales supporter here!

 

[DanteAmor]

Hi and welcome to MrExcel!

It looks like a vlookup formula.
Check if this is what you need:

Book1
	A	B	C	D			G
1
2
3
4	codes	description	product	pack size			Price
5	123						100
6	456						200
7	789						300
8	852						400
9	963						500
Suppliers

Book1
	A	B	C	D	E
1	codes	description	product	pack size	Price
2	123				100
3	789				300
4	963				500
5
inventory

Cell Formulas
Range	Formula
E2:E4	E2	=VLOOKUP(A2,Suppliers!A:G,7,0)

 

[Dana20000]

Thank you Dante, have got it working in a fashion, formula works but cannot seem to highlight the cells with the correct formulas in and drag them down to the bottom of the worksheet to populate all my prices? Also, looking at the formula, why do we put the 7,0 at the end? Sorry for the newbie question

 

[DanteAmor]

but cannot seem to highlight the cells with the correct formulas in and drag them down to the bottom of the worksheet to populate all my prices

I do not understand what you mean.
You could put a sample of your data from the 2 sheets. Use XL2BB tool.

In this formula A is 1, B is 2, C is 3, D is 4, E is 5, F is 6 and G is 7.
That's why you have a 7 to get the value of column G.
And 0 means that the match must be exact.

 

[Dana20000]

Thank you Dante, think I understand, will try again later