need vocabulary, please

[killerleaf]

what is it called when you have two totally different separately named workbooks, say, pacu data, and pacu delay, and you want to compare column b in pacu data to column n in pacu delay, to see if there are any matching entries? I tried to do a search thru the archives, but I realized I don't know what to call this...especially to get results from the search...any and all suggestions are appreciated!

 

[Oaktree]

To compare two columns, use the match function, as in the trivial example below. Just change the references to be different workbooks in addition to different columns.

Book3
	A	B	C	D	E
1	column 1	match to column 2		column 2	match to column 1
2	1	#N/A		5	6
3	2	#N/A		6	7
4	3	#N/A		7	#N/A
5	4	#N/A		8	#N/A
6	5	2		9	#N/A
7	6	3		10	#N/A
Sheet1

 

[killerleaf]

thanks! at least now i can look up the help files, so i can figure how to reference the different workbooks! thanks!