Hi,

I have repeating data in column A and data assigned to that in column b. I
want to populate that data in a different cell using vlookup. but since
column A is repeating, only the first value in column B is populated.

Policy Name
4060017901 CRS Insured Name 1
4060017901 CRS Insured Name 6
4060017901 CRS Insured Name 11
4060017901 CRS Insured Name 18
4060017901 CRS Insured Name 23
4060017901 CRS Insured Name 30
4060017901 CRS Insured Name 35
4060017901 CRS Insured Name 42
4060017901 CRS Insured Name 47

I have a different worksheet with policy #'s but i need to populate the name
in that worksheet. bbut using vlookup only CRS Insured Name 1 is populated
all the time. What do i DO? plz suggest