Index Match across multiple tabs

[seraja27]

Hi, I am working on an index-match function. When I do it on the tab with the data it works fine, but when I do it on another tab it does not work...my formula is as follows...

{=INDEX('Sheet1'!AB30:AB92,MATCH(A6&B6,'Sheet1'!C30:C92&'Sheet1'!B30:B92,0))}

 

[seraja27]

I made a really stupid mistake...there was a space after the text in one of the cells which would obviously not get picked up.

Thank you for your help

 

[XOR LX]

Ah! Oh well, at least you found the issue!

Regards