View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
khers khers is offline
external usenet poster
 
Posts: 3
Default (Please Help) Merge coloms based on equal rows with information

Hi
I have a sheet with this information

Card# Name Surname
1 A Alast
2 B Blast
3 C Clast
4 D Dlast

and another sheet with this information

Student# Name Surname
22 B Blast
11 A Alast
33 C Clast
55 E Elast

I need to extract Card# and Student# by comparing Name and Surname and
get this list

Card# Student# Name Surname
1 11 A Alast
2 22 B Blast
3 33 C Clast

many thanks in advance