Notifications
Clear all
Topic starter
Hi !
I have lookup values in column A which are duplicates and i have to apply vlookup in column B and in column B i need vlookup answer for first value and then blank for duplicate/repeating values. please guide.
| Emp ID | Emp Name |
| 1054 | |
| 1056 | |
| 1054 | |
| 1054 | |
| 1078 | |
| 1056 | |
| 1196 | |
| 1284 | |
| 1196 | |
| 1196 | |
| 1284 | |
| 1078 | |
| 1196 | |
| 1284 | |
| 1333 | |
| 1368 |
Posted : 01/08/2018 6:31 am
Hi Irfan
Give this a try.
What I am doing is counting the Emp ID in column A to see if it already exist (If count is >1 then already exist)
It will only VLOOKUP if the count is 1. Pay attention to the $ sign as I need to lock some cells to make them absolute.
Hope this helps.
Sunny
Posted : 01/08/2018 10:11 am