If you want to look in all sheets in the workbook a macro would be better.
This will look in col C and if found show what's in the column 18 to the
right.

Sub findinsheets()
what = "x"
On Error Resume Next
For i = 1 To Sheets.Count
MsgBox Sheets(i).Columns(3).Find(what).Offset(, 18)
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Malley87" wrote in message
...
Ok I'm pretty sure I have to use several functions together to do this,
but
I'm not sure which ones or how... I want to search a different excell
document for a # in a column on all the sheets in that document, & then I
want the computer to automatically give me the value from a different
column
on that row. I that I needed to use offset & search but its just not
working
right. I had tried =offset(=search(#, ['document']! $C:$C, 1) 0, 18) But
it
keeps wanting to put a specific sheet out of that document, & I need it to
search all of them. Please let me know if you have any idea what I'm
supposed
to be doing. Because right now I have to manually search each one & there
are
usually 20 for each sheet. & several documents need that information