VLookup without Unique information

[Guest]

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,

 

[Guest]

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.

 

[Guest]

Thats great Toppers.
Much appreciated

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.