Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Return Specific Value using VLOOKUP ?

Posted on 2014-03-07
Medium Priority
285 Views
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
0
Question by:LubinofS
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 35

Accepted Solution

mvidas earned 2000 total points
ID: 39913230
Hi LubinofS,

Enter the following into C2:

=IF(COUNTIF(\$A\$2:\$A\$8085,A2)=1,B2,IF(COUNTIFS(\$A\$2:\$A\$8085,A2,\$B\$2:\$B\$8085,"RFG")>0,"RFG",IF(COUNTIFS(\$A\$2:\$A\$8085,A2,\$B\$2:\$B\$8085,"FRZ")>0,"FRZ",IF(COUNTIFS(\$A\$2:\$A\$8085,A2,\$B\$2:\$B\$8085,"CHO")>0,"RFG",""))))

Matt
0

Author Closing Comment

ID: 39913261
Thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
###### Suggested Courses
Course of the Month9 days, 14 hours left to enroll