View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NTK NTK is offline
external usenet poster
 
Posts: 2
Default Lookup where column data does not match

Hi,

I have a problem where for example;

Sheet1 column A1 contains data
12345678
23456765

Sheet2 column A1 contains data
Joe Bloggs12345678
Jane Bloggs23456765


An so on and so on
Can someone help me with a formul to look one set of data against the other
and put the result on sheet1

A1 B1
12345678 Joe Bloggs12345678
23456765 Jane Bloggs23456765

Any help is appreciated,
Thanks