PDA

View Full Version : Search for number in another Excel file and get adjacent cell



itunes1995
07-30-2018, 04:04 AM
Hello,
after a long time searching by myself I'll ask in this thread, because I wasn't able to handle it.
I would like to lookup for a number (item ID) in another excel file and get the adjacent cell value (article-description).

It would be the best that the article-description will be looked-up by calling the function, because it's not static as u can see as well in the screenshot.

In this example: At the first time the article-description ("article-name1") should be written inside B6 of file1.xls and after that "article-name3" should be written inside B17.
I hope with the screenshot it's understandable.


22642

Thanks and best regards.