VLookup without Unique information
 

Is it possible to use VLOOKUP if some of the corresponding info is not unique?
eg. I have two columns of data, one column detailing personel numbers, the
other detailing what their % commision is.
The problem I have is that a number of different people have the same
commision rates, so although I have done VLOOKUP (searching by personnel
number), i keep getting N/A# in the cell instead of getting a commision rate.
Any ideas, as there are hundreds of rows of data that I need to check.

Thanks in advance,

VLookup without Unique information
 

As the personnel numbers are unique then check format of /data in this
column e.g is it a mixture of text and numbers; it's this column with problem
not duplicate commission rates.

You will get #N/A if you compare unlike formats.

"Greenback" wrote:

Is it possible to use VLOOKUP if some of the corresponding info is not unique?
eg. I have two columns of data, one column detailing personel numbers, the
other detailing what their % commision is.
The problem I have is that a number of different people have the same
commision rates, so although I have done VLOOKUP (searching by personnel
number), i keep getting N/A# in the cell instead of getting a commision rate.
Any ideas, as there are hundreds of rows of data that I need to check.

Thanks in advance,

VLookup without Unique information
 

Thats great Toppers.
Much appreciated

"Toppers" wrote:

As the personnel numbers are unique then check format of /data in this
column e.g is it a mixture of text and numbers; it's this column with problem
not duplicate commission rates.

You will get #N/A if you compare unlike formats.

"Greenback" wrote:

Is it possible to use VLOOKUP if some of the corresponding info is not unique?
eg. I have two columns of data, one column detailing personel numbers, the
other detailing what their % commision is.
The problem I have is that a number of different people have the same
commision rates, so although I have done VLOOKUP (searching by personnel
number), i keep getting N/A# in the cell instead of getting a commision rate.
Any ideas, as there are hundreds of rows of data that I need to check.

Thanks in advance,