Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell nested function question....
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested IF question | Excel Worksheet Functions | |||
Nested IF question | Excel Discussion (Misc queries) | |||
Nested if question | Excel Discussion (Misc queries) | |||
IF NESTED Question | Excel Worksheet Functions |