Hello all.
I new here so I hope I write my question at right place. I need your help.
I have a workbook with multiple sheets and I create one sheet called DATA+sheetlist of all sheets at workbook.
At all sheets In column B3:B1000 I have order numbers at columns C3:C1000 company names and at columns R3:R1000 values.
At DATA sheet at column B3:B1000 I create order numbers + company names which I need (order number&" "&company name) as example: 2002514 CCLA-PBC-S5F
So what exactly I need is to return the sheet name at DATA sheet at columns C3:C1000. So lookup value (cell B3 till B1000 at DATA sheet) check columns B and C at all sheets at workbook, if match check column R and if this value is bigger than 0 he will return the sheet name.
Is it possible with functions?
thank you guys
I new here so I hope I write my question at right place. I need your help.
I have a workbook with multiple sheets and I create one sheet called DATA+sheetlist of all sheets at workbook.
At all sheets In column B3:B1000 I have order numbers at columns C3:C1000 company names and at columns R3:R1000 values.
At DATA sheet at column B3:B1000 I create order numbers + company names which I need (order number&" "&company name) as example: 2002514 CCLA-PBC-S5F
So what exactly I need is to return the sheet name at DATA sheet at columns C3:C1000. So lookup value (cell B3 till B1000 at DATA sheet) check columns B and C at all sheets at workbook, if match check column R and if this value is bigger than 0 he will return the sheet name.
Is it possible with functions?
thank you guys