Completing table using information from other spreadsheet

[siravac]

Dear everybody,

I'm working about listing of published scientific article for my organization now, and I have to complete the table that look like this one.

snapshot2.png

I'd like to fill the 'AQ' column with the values called Impact Factor (which is something like 'ranking' for each scientific journal) and those values can be found in my other spreadsheet which look alike these

snapshot1.png

For example, I'd like to fill the value '0.589' (Impact Factor, from the first row of the second spreadsheety) in every the 'AQ' columns (of the first spreadsheet) whose 'AF' (ISSN, a coding number for each scientific journal) is 0001-5512

If this is confusing, I'm sorry but I find hard to explain

Thanks a lot

[JBeaucaire]

In AQ2 you could use a VLOOKUP. Make sure both workbooks are open, then the formula would be something like this:

=VLOOKUP(AF2, [MyOtherWorkbook.xlsx]Sheet1!D:F, 3, 0)

Your pictures make it virtually impossible to suggest a working formula, this is intended to give you the syntax and you work out the specifics. VLOOKUP is the tool, press F1 and read the Excel tutorial on this function if you're not familiar with it.

Also, it's worth noting that in your two pictures, there are no matches between column AF in the first pic and then ISSN examples of the second picture.

[siravac]

Thanks for your advice, I tried VLOOKUP but still getting error

May I asked you for a favor?

The VLOOKUP script I typed shown here

ms.jpg

The spreadsheet providing values for Impact Factor is here

ms2.jpg

What the correct formula should be?

[hoyasaxa215]

Replace "D5:D7" with "D:F". You need to include all three columns.

[JBeaucaire]

Pictures are so frustrating. Attach a slimmed down version of your workbook with sample data in it you KNOW should match.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic