VLOOKUP-type formula required for partial text matche in multiple spreadsheets

So for 'Drugs. 2012 Sep 10;72(13):1739-53.' you want to perform a lookup to find the Impact Factor from another sheet using Drugs as the lookup value? If so how will the formula know you are looking for the word Drugs?

Will every entry on the Bibliography sheet be in the same format (Drugs. 2012 Sep 10;72(13):1739-53.)? If so I assume that you want to extract the text before the first full stop and then use this as your lookup value.

If so the attached file will help you. Very basic to show you what to do, you just need to apply it to your work.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

Always glad to help. Good luck with the rest of your work!