Forum Discussion

Dusandza's avatar
Dusandza
Copper Contributor
Apr 21, 2022

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   
IDCharacteristic IDCharacteristic  
1 what formula to enter? x  
2  x  
3  y  
4  y  
5  y  
1      
5      
6      
7      
8      

 

thanks in advance!

 

19 Replies

    • Dusandza's avatar
      Dusandza
      Copper 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.

Resources