edmund1985
New Member
- Joined
- Jun 24, 2016
- Messages
- 3
Hi all,
I'm trying to come up with a formula that will populate unique cells in a new worksheet by referencing another worksheet that contains all the data.
So far I've used an INDEX MATCH formula, but that takes across all cells and displays the contents of the desired ones, while producing #N/A for the others.
Example
The data set looks something like this:
<tbody>
</tbody>
The formula I'm using is below:
=INDEX('Sheet1'!A2,MATCH("White",'Sheet1'!B2,0))
And the result in Sheet 2 looks like this:
<tbody>
</tbody>
I'd like if the '#N/A' cells weren't returned at all, i.e. for it to look like this:
<tbody>
</tbody>
Does anyone know if that's possible?? Thanks in advance for any help!!!
I'm trying to come up with a formula that will populate unique cells in a new worksheet by referencing another worksheet that contains all the data.
So far I've used an INDEX MATCH formula, but that takes across all cells and displays the contents of the desired ones, while producing #N/A for the others.
Example
The data set looks something like this:
Unique ID | Colour |
101 | White |
102 | White |
103 | Red |
104 | White |
105 | Red |
106 | White |
<tbody>
</tbody>
The formula I'm using is below:
=INDEX('Sheet1'!A2,MATCH("White",'Sheet1'!B2,0))
And the result in Sheet 2 looks like this:
Unique ID |
101 |
102 |
#N/A |
104 |
#N/A |
106 |
<tbody>
</tbody>
I'd like if the '#N/A' cells weren't returned at all, i.e. for it to look like this:
Unique ID |
101 |
102 |
104 |
106 |
<tbody>
</tbody>
Does anyone know if that's possible?? Thanks in advance for any help!!!