I can't get my head round this one, and Googling solutions I'm beginning to wonder if it is possible without VBA...
I have a bibliography in Excel with referencing information in each cell - for example: 'Drugs. 2012 Sep 10;72(13):1739-53.' There are a couple of thousand of these.
On another sheet, I have a list of different journal titles in range A2:A239 including 'Drugs', and in column E I have an 'Impact Factor' number that corresponds with those eg. '4.633' (this does not have to be formatted as a number - it could just as easily be a text string).
So on the bibliography sheet, I would like to create a formula that allows me to lookup the journal 'Drugs' (using a partial text match due to the other information in the cell) from the second sheet and return the Impact Factor value that corresponds with it to the bibliography sheet.
Once I have a formula that can actually achieve this I will be able to work out the wildcard values to make sure I don't get erroneous returns on the lookups.
Is this possible? Looking forward to your thoughts!