Thanks guys, it looks =if(isnumber(match(c2,A:a,0)),index(b:b,match(c2,a :a,0))
,"No Match")
worked the best for me.

Worked like wonders!

Noel

Dave Peterson wrote:
maybe...
=if(isnumber(match(c2,A:a,0)),index(b:b,match(c2, a:a,0)),"No Match")
or
=IF(iserror(match(C2,a:a,0)),"no match",index(b:b,match(C2,A:A,0)))
or
=if(iserror(vlookup(c2,a:b,2,false)),"no match",vlookup(c2,a:b,2,false))

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

I'm having trouble writing a formula to insert specific values from a column
that was a result of a match with a column adjacent to it.
[quoted text clipped - 20 lines]

Noel


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1