Hi
You could try this formula to change wk2 data to first & last name presuming
there is a space between names eg
smith john
assuming data in column a

=concatenate(mid(a1,find(" ",a1)+1,len(a1))," ",mid(a1,1,find(" ",a1)-1))
then use vlookup
or in one formula on wk2 presuming data on wk1 on sheet1 column a
=if(isna(vlookup(concatenate(mid(a1,find(" ",a1)+1,len(a1)),"
",mid(a1,1,find(" ",a1)-1)),[wk1]sheet1!a:a,1,false)),"no match","match"))
Hope this helps
Tina

"Mzansi" wrote:

I have 2 workbooks, In WK1 Data is listed as (First & Last name) in a single
cell. In Wk2 data is listed as (Last & First name) also in a single cell. Now
i need to compare or match entries in both workbooks. I tried VLOOKUP but its
not picking up bcoz the text strings have been transposed.

Pls can anyone help
Tnx