On Mar 23, 4:21*pm, Benjamin
wrote:
I need to look for this value within a cell

i.e.
A1XT-4-0713-01-00021-1.PDF

within Folder:Folder:Folder:Folder:FolderPath:A1XT-4-0713-01-00021-1.PDF
*then return that row's third column's value.

=SUMIF(A2,"*"&"A1XT-4-0713-01-00021-1.PDF"&"*",C2)

IF A2 contains the string it will pick up the value in column C. This
is intended for a single row,,, to be copied vertically to the extent
of the database.