Index Match Help

[Blair333]

Hi,

I need to do an index match formula where I am matching case #'s in two different worksheets' columns and then output the data from sheet 2 into a new column into sheet 1.

I tried this formula: =INDEX('Sheet 1'!$E$2:$H$1811,MATCH(1,('Sheet 2'!$C$3:C$28=Sheet 1!E2)*('Sheet 1'!$M$2:$M$1811=Sheet 2!C2),0))

 

[KRice]

Welcome to the MrExcel board! Your description isn't clear enough to advise. It looks as though you want something from 'Sheet 1'!$E$2:$H$1811, but is that "something" the contents of a single cell or a range of cells? This part...('Sheet 1'!$M$2:$M$1811=Sheet 2!C2)...requires that C2 on Sheet 2 finds a match somewhere in M2:M1811 on Sheet 1. The other part of the formula makes no sense...('Sheet 2'!$C$3:C$28=Sheet 1!E2)...as it covers a range of only 26 rows while the main Sheet 1 range covers 1810 rows. How would you know which of the 4 columns in 'Sheet 1'!$E$2:$H$1811 is the one of interest?