A
andrei
Could not say better in subject but this is what i need :
In column A i have book titles , in column B i have their book authors , in
column C i have a lot of authors ( all authors in column B are to be found in
column C ) and in column D i have for each author a code . Something like
that :
A1 : A Fiery Peace in a Cold War
A2 : The National Parks: America's Best Idea
A3 : Dancing in the Dark: A Cultural History of the Great Depression
B1 :Neil Sheehan
B2 ayton Duncan
B3 :Morris Dickstein
C1 : John Keegan
C2 : Morris Dickstein
C3 : Rick Bragg
C4: Neil Sheehan
C5: Dayton Duncan
D1 : 1
D2 : 2
D3 : 3
D4 : 4
D5 : 5
In column E i need the code which corespondes to the author of the book in A
column . So , in A1 i have a book written by "Neil Sheehan" , so in E1 i
need the code "4" , because the author "Neil Sheehan" has this code
Can this be done ?
In column A i have book titles , in column B i have their book authors , in
column C i have a lot of authors ( all authors in column B are to be found in
column C ) and in column D i have for each author a code . Something like
that :
A1 : A Fiery Peace in a Cold War
A2 : The National Parks: America's Best Idea
A3 : Dancing in the Dark: A Cultural History of the Great Depression
B1 :Neil Sheehan
B2 ayton Duncan
B3 :Morris Dickstein
C1 : John Keegan
C2 : Morris Dickstein
C3 : Rick Bragg
C4: Neil Sheehan
C5: Dayton Duncan
D1 : 1
D2 : 2
D3 : 3
D4 : 4
D5 : 5
In column E i need the code which corespondes to the author of the book in A
column . So , in A1 i have a book written by "Neil Sheehan" , so in E1 i
need the code "4" , because the author "Neil Sheehan" has this code
Can this be done ?