Craig Peter DG
New Member
- Joined
- Sep 10, 2016
- Messages
- 33
- Office Version
- 2013
Hi folks
In my table array I have quite a few duplicate item numbers in Column A. I need them to stay in there as i have referenced the duplicates in other function outputs. However, for one of my function outputs i actually want to IGNORE those duplicate values and only give me a result based on each UNIQUE item number. Anyone suggest a modification to the VLOOKUP function I would use please? Or is not a VLOOKUP i need at all?
In my table array I have quite a few duplicate item numbers in Column A. I need them to stay in there as i have referenced the duplicates in other function outputs. However, for one of my function outputs i actually want to IGNORE those duplicate values and only give me a result based on each UNIQUE item number. Anyone suggest a modification to the VLOOKUP function I would use please? Or is not a VLOOKUP i need at all?