View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NeedExcelHelp07 NeedExcelHelp07 is offline
external usenet poster
 
Posts: 30
Default how to match data

I have 3 worksheets of data. The master worksheet is called ipc. The other
two worksheets are called, vb and pb.
Each row cell is 14 characters long.
IPC is the master worksheet and I want to match the data in row D up to the
first 8 chracters in worksheets vb and/or pb. In column f in worksheet ipc,
if there is a match between the first 8 characters in row d in vb or pb, I
want row d from the match row to be displayed on row f. If there's no match,
it can say FALSE.

I'm looking for any formula or function to make this work.

Thanks!