Forum Discussion
Excel formula with if and vlookup ?
First of hello Community!
I am using :
Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20272) 64-bit
I need VLOOKUP and IF formula with more conditions, maybe even some other formula:
I have two tables:
First table is with list of data of numbers.
Second Table where these numbers are grouped by same characteristics.
I need some kind of IF and VLOOKUP (or something else) to:
1. If only one ID with characteristic is in first table don't return data.
2. If only one ID with characteristic is repeating don't return data.
3. if there are two or more ID with same Characteristic, then return Characteristic in first table behind each ID.
list of data | Characteristic per data | |||||
ID | Characteristic | ID | Characteristic | |||
1 | what formula to enter? | 1 | x | |||
2 | 8 | x | ||||
3 | 2 | y | ||||
4 | 5 | y | ||||
5 | 7 | y | ||||
1 | ||||||
5 | ||||||
6 | ||||||
7 | ||||||
8 |
thanks in advance!
19 Replies
- JKPieterseSilver ContributorIf I read it correctly, 1 and 2 contradict each other?
- DusandzaCopper Contributor
JKPieterse yes, they are not the same value but unique: "1" has its specifications but is under same characteristic "X" and "8" has its specifications different from "8", but is under same characteristic "x" as 1.
- JKPieterseSilver ContributorI'm sorry, I have no idea what you mean 😞