How to look up a value within only a subset of another column?
Closed
Rachel
-
Sep 1, 2017 at 02:12 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 1, 2017 at 10:27 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 1, 2017 at 10:27 AM
Related:
- How to look up a value within only a subset of another column?
- Excel copy column from one sheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- How to increment numbers when value changes in another column? - Excel Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
- How to repeat rows a specified number of times based on another column in excel - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 1, 2017 at 10:27 AM
Sep 1, 2017 at 10:27 AM
Rachel, Good morning.
Suppose yoUr data at A1:C5
Try do use:
D1 --> =IF(COUNTIFS($A$1:$A$5,A1,$B$1:$B$5,C1)=0,"No","Yes")
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose yoUr data at A1:C5
Try do use:
D1 --> =IF(COUNTIFS($A$1:$A$5,A1,$B$1:$B$5,C1)=0,"No","Yes")
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
