Problem statement: column of data in one sheet (sample) and master data (population) in another sheet. Aim to validate if the sample data exists in the population data by using Vlookup.
data attached.
Current result: is returning all one result, that is [USD].
this is incorrect as upon spot checking there are clearly other currencies. In passing this is only a sample of data, actually there are about 1000 samples needed to be checked.
please advise.
thanks.
MM
Bookmarks