kevo
Well-known member
- Mar 8, 2008
- 9,120
Hello NSC Excel bods. Can anyone help with the following?
I need to reference a value in a formula. But rather than having the actual text in the formula I need it to refer to a value in a list. As cells in the data can contain multiple values, I need to specify that the cell contains the text rather than being an exact match.
So say if my list is:
A2 Apples
A3 Oranges
A4 Pears
As part of my formula, I would normally (for apples) put "*Apples*" to return all cells that contain the word apples.
However if I want to refrence the cell in the list instead, *$A$2* doesn't work.
Using asterisks to denote 'contains' doesnt work when referencing a value in a cell.
(For an exact match "Apples" and $A$2 both of course work).
How can I specify 'contains' when using a cell reference rather than the actual text in the formula?
I need to reference a value in a formula. But rather than having the actual text in the formula I need it to refer to a value in a list. As cells in the data can contain multiple values, I need to specify that the cell contains the text rather than being an exact match.
So say if my list is:
A2 Apples
A3 Oranges
A4 Pears
As part of my formula, I would normally (for apples) put "*Apples*" to return all cells that contain the word apples.
However if I want to refrence the cell in the list instead, *$A$2* doesn't work.
Using asterisks to denote 'contains' doesnt work when referencing a value in a cell.
(For an exact match "Apples" and $A$2 both of course work).
How can I specify 'contains' when using a cell reference rather than the actual text in the formula?
