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