Thread: How do I compare data in 2 workbooks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mzansi Mzansi is offline
external usenet poster
  
Posts: 1
Default How do I compare data in 2 workbooks
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
Reply With QuoteReply With Quote