Hi
In Column A I have a series of report numbers.
In Column B I have the file names. Some contain the word Report followed by a number that would appear in Column A
So in Column C I need a formula that looks at the value in column A, and if that number appears in Column B (Always will follow the word "Report") I need to have "Related file xxxxxx" appear. The file number will always be a 6 digit number
Thanks in advance
In Column A I have a series of report numbers.
In Column B I have the file names. Some contain the word Report followed by a number that would appear in Column A
Column A | Column B | |
123456 | iguiguy | Related file 123567 |
123457 | ihohioh | |
123567 | Report 123457 | |
124594 | hdiuhds hiohsodhohohoik | Related file 125500 |
125500 | Report 124594 |
So in Column C I need a formula that looks at the value in column A, and if that number appears in Column B (Always will follow the word "Report") I need to have "Related file xxxxxx" appear. The file number will always be a 6 digit number
Thanks in advance