Thread: Match and copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Match and copy

Look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Janette" wrote in message
...
I'm looking for some help for the following.
I have two sheets in one workbook. One sheet contain the parcel number
and
owner. The other sheet contains a parcel number (identical to the first
sheet) and an address. I need to lookup the parcel number and match it to
the other hence combinding the address and owner to the same parcel
number.
Thanks in advance -and this is a great website containing loads of helps!
--
Janette