The fourth parameters is set false because I am cross-referencing data
appearing in one sheet that doesn't appear in another. The problem is
that some words will show up a few different times with different data
attached in corresponding cells. Some of the words also appear in
varying orders, but I need vLookup to include those as well. Setting
the fourth parameter to true or false or grab that data.

I was told that there is a way to alphabetize the data within a cell
though. With that I could get the data I need but I have no idea what
function in excel can do this. I know this is all a little vague, but
thats because the work I do in excel is not number-based and a little
tricky to understand.


--
tonerockyhorror
------------------------------------------------------------------------
tonerockyhorror's Profile: http://www.excelforum.com/member.php...o&userid=34136
View this thread: http://www.excelforum.com/showthread...hreadid=539056