I am looking to search a 2 column pivot table located in a different workbook. Column A contains text and Column B contains a figure associated with the text. I would like to search for a text string and if the search finds it, to return the value in the adjacent cell into the workbook where the macro was assigned to. I dont really know where to begin with this but some sort of VBA code would be appreciated and i'll be happy to play from there.

The text column in the pivot table is something along the lines of Loop 00, Loop 01, Loop 02 etc etc and the associated figures could be any numerical value.

Thanks in advance!