Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a workbook that has two sheets. The first sheet is called
'Objects' and the second sheet is called 'RawData'. The 'Objects' sheet has values down the A column. There are about 4,000 rows. The values are just simple strings. In the 'RawData' sheet, I just have output of code from an entire application. So basically, it is a bunch of text. How can I find out if the string in A1 (then A2, A3, A4....) exists anywhere within the 'RawData' sheet? If it does exists then I just want to put a '***' (or any type of flag) on B1 (or B2, B3, B4...) in the 'Objects' sheet, and if the string isn't in the 'RawData' sheet, then leave cell B1 blank. Thank You, Jon Wetzel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
worksheet linked to a cell | Excel Worksheet Functions | |||
Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
update cell in other worksheet based... | Excel Worksheet Functions | |||
macro help | Excel Discussion (Misc queries) | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |