Hi all,
I am trying to automate a look up between a spreadsheets with two tabs ("Print" and "match").
I need a formula in column B of the "Print" tab that will look at column A of the "print" tab and compare it to column A in the "match" tab. For example, In cell A2 of the "print" tab, it says 'Lilac verbana rock the dock'. If you scan column A of the 'Match' tab, you will see that there is a 'rock the dock' listing - therefore we want to insert the word PRINT into the cell.
One of the issues is that the cell contents are not exactly right, but rock the dock was a part of the name.
Can anyone help me?
Casey
Bookmarks