How to retrieve data from another column next to the string you search for.

[ESEKOCK]

Hi,
I try to search for a string in column A in several workbooks and want to retrieve the data in column D when I found the string I search for.
I found a formula almost working with the exception that it shows the colum I search for. Are there any easy way I can change the last statement in the below formula so it shows the data in column D instead of the String value I search for in column A?

If xFound Is Nothing Then
Exit Do
Else
xCount = xCount + 1
xRow = xRow + 1
.Cells(xRow, 1) = xWb.Name
.Cells(xRow, 2) = xWk.Name
.Cells(xRow, 3) = xFound.Value

[AlphaFrog]

This offsets 3 column from xFound in column A to column D

Please Login or Register  to view this content.

[ESEKOCK]

Many thanks. You saved me lots of time.

Very much appreicated.

Br Thomas