Desperately Need Index Solution

[nancybrown]

My spreadsheet has two tabs: 2009Terms; 2008Terms. Each tabs have similar columns: A=Vendor ID; B=Inv#; C=Terms. I need to match A&B from both tabs and bring C=Terms from 2008 into the 2009 tab. This is what I'm using, but it returns #N/A for everything.

Column D added to concatenate A2,B2 on both tabs: =concatentate(a2,b2)

=INDEX(2008Terms!$C$2:$C$64000,MATCH(2009Terms!D2,2008Terms!$D$2:$D$64000,0))

Can any tell me what I am doing wrong please??

 

[shyrath]

Not the most elegant.
But I would use a "key" column to match both and use vlookup.
Like below example.
For ease of reading i put both sheets in one.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	SHEET2008	Key	VendorID	Invoice	Terms	SHEET2009	Key	VendorID	Invoice	Terms
2		1234121	1234	121	A		1234121	1234	121	A
3		1235122	1235	122	B		1235122	1235	122	B
4		1236123	1236	123	C		1236123	1236	123	C
5		1237124	1237	124	D		1237124	1237	124	D
6		1238125	1238	125	E		1238125	1238	125	E
7		1239126	1239	126	F		1239126	1239	126	F
8		1240127	1240	127	G		1240127	1240	127	G
9		1241128	1241	128	H		1241128	1241	128	H
10		1242129	1242	129	I		1242129	1242	129	I
Sheet3

 

[schielrn]

It doesn't look like there is a problem with your current formula, unless there is some sort of formatting issue? Maybe try:

=index(2008Terms!$C$2:$C$64000,match(1,(2008Terms!$A$2:$A$64000=2009Terms!A2)*(2008Terms!$B$2:$B$64000=B2),0))

This needs to be confirmed with control+shift+enter and not just enter. I believe it will net the same results and you might want to make sure that the term you are looking up in 2009 is in fact on the 2008 sheet and exactly the same?

Hope that helps.

 

[nancybrown]

I'll give it a try. Thank you.