LubinofS
asked on
Return Specific Value using VLOOKUP ?
I got one list with some values that might be duplicated, however, column associated with it is different, like: ( possible values are only 4 DRY,RFG,FRZ,CHOC )
1 DRY
1 RFG
2 RFG
3 FRZ
Every time I have duplicates, as the first 2 rows, I would like to apply and specific value, in this specific example the value would be "RFG" ...how can I do it ?
This would be the rules :
1. Unique values keep their 2nd column value
2. Duplicates that contain RFG should be consolidated as RFG
3. Duplicates that contain FRZ should be consolidated as FRZ
4. Duplicates that contain CHOC should be consolidated as RFG
Example.xlsx
1 DRY
1 RFG
2 RFG
3 FRZ
Every time I have duplicates, as the first 2 rows, I would like to apply and specific value, in this specific example the value would be "RFG" ...how can I do it ?
This would be the rules :
1. Unique values keep their 2nd column value
2. Duplicates that contain RFG should be consolidated as RFG
3. Duplicates that contain FRZ should be consolidated as FRZ
4. Duplicates that contain CHOC should be consolidated as RFG
Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER