Hello Everyone,
I could really use a hand creating a formula to perform the following task:
(See Sample Spreadsheet)
Check to see if the book title in A2 (sheet 1), matches the book title in A2 (sheet 2)
If they are a match,
Copy the ISBN numeber from C2 (sheet 2) to C2 (sheet 1)
I'm sure this is pretty straight forward, but I can't seem to figure it out. Any suggestion would be greatly appreciated! Thanks in advance!
Last edited by jccola; 08-30-2011 at 11:27 AM.
Every title in Sheet2 column A has a leading space that is not present in the titles in Sheet1 column A.
If you intend keeping this difference then try...
=IF(ISNUMBER(MATCH(" "&A2,Sheet2!A:A,0))*(ISNUMBER(INDEX(Sheet2!C:C,MATCH(" "&A2,Sheet2!A:A,0)))),INDEX(Sheet2!C:C,MATCH(" "&A2,Sheet2!A:A,0)),"")
in Sheet1!C2 filled down to C16 or further.
If you intend removing all of those leading spaces, then after they have been removed try...
=IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0))*(ISNUMBER(INDEX(Sheet2!C:C,MATCH( A2,Sheet2!A:A,0)))),INDEX(Sheet2!C:C,MATCH(A2,Sheet2!A:A,0)),"")
Beau Nydal
In Cell # C2 of sheet 1 use
=VLOOKUP(A2,INDEX(TRIM(Sheet2!$A$1:$C$16),0),3,0)
or
=INDEX(Sheet2!$C$1:$C$16,MATCH(A2,INDEX(TRIM(Sheet2!$A$1:$A$16),0),0))
and copy down
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thanks so much guys! Both formulae worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks