Hello,
I would like to check if an unique ID from the first tab (Data) is present in the second tab (Groups).
I tried to VLOOKUP the original ID's in the first case but not all matches are displayed correctly.
Figured this might be due some format differences, so I tried to create a separate column that converts the string to text first.
However.. after doing so the VLOOKUP returns the 0 value..
Could someone take a look at the example sheet? and let me know how I can return the original ID in column B if a match has been found?
Instead of the 0's that are being returned at the moment?
Thanks in advance
~ Niels
Bookmarks