Try this sample, which shows it working the way it should:
http://freefilehosting.net/download/3la03
index n match multi-criteria.xls

You might have been hit by the line break in the term below when you copied
n pasted the formula into B1 earlier:

... TRIM(Sheet2!$A$1:$A$100&" "&Sheet2!$B$1:$B$100) ..

There's a concat of a single space above which you need to amend in B1's
formula bar, post pasting it, before you confirm the formula with
CTRL+SHIFT+ENTER
(Refer to the sample's B1 in Sheet1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"Jeremy" wrote:
For some reason this did not work for me.