Line up two columns of data?

[adorr]

Hi there,

I need help lining up two columns of data. For some reason I'm not having any luck using match, lookup, and index formulas...

Basically, I have a small set of data (a few hundred rows) that I want to line up with a much larger column of data, and I want to align them based on their case numbers.

Thanks!

 

[RudiS]

You should be able to use VLOOKUPS.
Just make sure the data types in the lookup value are the same data type (number to number, or text to text)

Example:

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	MAIN LIST								EXTRA DATA to line up with MAIL LIST
2
3	Case #	Order Date	Name	Order Total	Info1	Info2			Case #	Info1	Info2
4	1	2014/04/13	Margaret Peacock	725.781					8	More info	Still more info
5	2	2012/11/26	Nancy Davolio	1067.0058	More info	Still more info			2	More info	Still more info
6	3	2012/12/06	Janet Leverling	90.1968					5	More info	Still more info
7	4	2012/12/04	Steven Buchanan	2643.4092	More info	Still more info			4	More info	Still more info
8	5	2013/05/28	Margaret Peacock	970.083	More info	Still more info			7	More info	Still more info
9	6	2012/10/24	Margaret Peacock	804.6804					10	More info	Still more info
10	7	2014/03/24	Michael Suyama	83.2998	More info	Still more info
11	8	2014/01/05	Janet Leverling	369.2916	More info	Still more info
12	9	2013/04/22	Janet Leverling	1836.426
13	10	2013/07/29	Laura Callahan	93.4002	More info	Still more info
14	11	2013/11/05	Steven Buchanan	250.9083
15
16
Sheet1

Cell Formulas
Range	Formula
E4	=IFERROR(VLOOKUP(A4,$I$4:$K$9,2,0),"")
F4	=IFERROR(VLOOKUP(A4,$I$4:$K$9,3,0),"")