your second "productID" is a named range of cells.... remember that in a match all that you want to do is look at a single cell first (ie "what" then "where"), not a whole list
also, your product table bit in the formula, again, is a table, not just a single column. As the example says, you need just a single column here to interrogate. This should be easy if you've named it like in your productid range
lastly, you're asking index to look at productid range in the very first part of your arguement where what you actually want returned is the info in your productname range, so as with the above, try replacing that first section so it looks at the range you named in respect of productname
you were nearly there first off, just a bit muddled up
does this help ?
Chris
This message was edited by Chris Davison on 2002-03-17 05:43
This message was edited by Chris Davison on 2002-03-17 05:45
This message was edited by Chris Davison on 2002-03-17 05:47