Things that happen

=IF(ISNA(VLOOKUP(A1,C$1:C$10,1,FALSE)),"No","Yes") A1 is checked against the list in C4 to C10

If you dont want the cell references to change when you copy and paste your formulas use $ signs. example: =$A1&B2. this will not change A's row, only columns. =$A$1 will not change both row or column

the 'line returns' appear in a cell as a small square in excel. To view these as seperate lines, try wripping text (right click, format cells, alignment tab)

need to have a formula check whether or not a particular value occurs within a range of data. For example, given the data set below: A 1 red 2 yellow 3 green 4 blue I need to be able to check whether that list contains a particular word. So something like: =ifcontains(A1:A4,"green","Yes","No"). So in this case, the "ifcontains" function would give me a "Yes", and =ifcontains(A1:A4,"orange","Yes","No") would evaluate to "No". Solution B1 = green =IF(COUNTIF(A1:A4,B1),"Yes","No")

Sub ExtractHL()     Dim HL As Hyperlink     For Each HL In ActiveSheet.Hyperlinks         HL.Range.Offset(0, 1).Value = HL.Address     Next End Sub

Sub RemoveHyperlinks() 'Remove all hyperlinks from the active sheet ActiveSheet.Hyperlinks.Delete End Sub instructions if you are new to macros: You will need to create a macro to delete the hyperlink addresses in your Excel sheet. Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press -F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting  Module  under the  Insert  menu. Paste the following code into your new module: Sub RemoveHyperlinks() 'Remove all hyperlinks from the active sheet ActiveSheet.Hyperlinks.Delete End Sub Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the  File  menu. Now, go to the sheet that contains the hyperlinks that you wish to delete. Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button. If you need to remove hyperlinks from other sheets, just repe...