bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 711
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have am using he following formula to put a value based upon a company name. Sometimes I get an error message because the criteria doesn't match the name on the destination worksheet.
The issue might be a period is in 1 name but not the other (Corp. instead of Corp) or corporation might be spelled for one customer name but not the other. I am trying to extract text from a different report not a value.
This is my formula. Should I replace that formula with one of the newer array formulas or is there another workaround:
"INDEX(DelphixDataExtractSalesOrdersP!C:C, MATCH("*" & 'Waterfall & Recon'!A8 &"*", DelphixDataExtractSalesOrdersP!U:U,0))"
For this example , A81 is "Common Securitization Solutions" but the name in the destination report is "Common Securitization Solution". So I get an error. I can't bring in the text I need to populate the report.
The text I am need to bring to be brought into this cell is "23Q!-053".
I changed the 0 in the March function to 1 (is this the relative match argument) but it pulled the wrong skew # and a different company name.
The yellow coded items is where the formula is located. If I find a match with the customers the result would be 23Q1-053. Yellow is my notation that that cell is hard - coded and not formula driven.
Thank you fo your help in advance.,
Michael
The issue might be a period is in 1 name but not the other (Corp. instead of Corp) or corporation might be spelled for one customer name but not the other. I am trying to extract text from a different report not a value.
This is my formula. Should I replace that formula with one of the newer array formulas or is there another workaround:
"INDEX(DelphixDataExtractSalesOrdersP!C:C, MATCH("*" & 'Waterfall & Recon'!A8 &"*", DelphixDataExtractSalesOrdersP!U:U,0))"
For this example , A81 is "Common Securitization Solutions" but the name in the destination report is "Common Securitization Solution". So I get an error. I can't bring in the text I need to populate the report.
The text I am need to bring to be brought into this cell is "23Q!-053".
I changed the 0 in the March function to 1 (is this the relative match argument) but it pulled the wrong skew # and a different company name.
The yellow coded items is where the formula is located. If I find a match with the customers the result would be 23Q1-053. Yellow is my notation that that cell is hard - coded and not formula driven.
Thank you fo your help in advance.,
Michael