Using INDEX and MATCH

[estein]

Hello everyone, I have two active worksheets. The first one is called 'Chart' and the second is 'Values'.

I have three columns of data. I would like to look in the first two, and return a value in the third.


=INDEX(Values!$C$1:$C$299,MATCH(Values!$D$1:$D$299,LEFT(Chart!A1:A16091,6)&" "&LEFT(Chart!C1:C16091,2)),0)

Values!$C$1:$C$299 => Result Matrix

Values!$D$1:$D$299 => Result of the concatenation of Column 1 with Column 2. So the result is like Column1_Space_Column2

LEFT(Chart!A1:A16091,6) => Cloumn1

LEFT(Chart!C1:C16091,2) => Cloumn2

I suspect that I am doing something wrong in the highlighted area. Any help is appreciated.