Hi,
I need some help with the followin:
Sheet1 - from 20 up to 600 rows:
list of shortnames (for example petsel for Peter Sellers) in column A and a value in column B. The list is not complete so it doesn't exactly match what's on sheet2. The list is in alphabetic order
A B
paulan 2
petsel 5
...
Sheet2 - about 600 rows:
translation list: with full name and surname (column A) and shortname (column B)
A B
...
Paul Landau paulan
Peter Sellers petsel
...
I need to compare sheet1 and sheet2 so that I get the full name and surname and the corresponding value.
A B
Paul Landau 2
Peter Sellers 5
Can someone help me with that?
Thanks
Francois
I need some help with the followin:
Sheet1 - from 20 up to 600 rows:
list of shortnames (for example petsel for Peter Sellers) in column A and a value in column B. The list is not complete so it doesn't exactly match what's on sheet2. The list is in alphabetic order
A B
paulan 2
petsel 5
...
Sheet2 - about 600 rows:
translation list: with full name and surname (column A) and shortname (column B)
A B
...
Paul Landau paulan
Peter Sellers petsel
...
I need to compare sheet1 and sheet2 so that I get the full name and surname and the corresponding value.
A B
Paul Landau 2
Peter Sellers 5
Can someone help me with that?
Thanks
Francois