Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Can you use the policy numbers for your criteria? Or Have you thought of using the filter? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519155 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yeah i am using my policy #'s as the unique field to populate the name in a
different worksheet. How is filter gonna help me tho??? "davesexcel" wrote: Can you use the policy numbers for your criteria? Or Have you thought of using the filter? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519155 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Nick
You say you are using policy ID as the unique filed, but it is not unique, it is repeated many times. It is only the combination of Policy Number & Name that is unique. I am assuming that on another sheet you have further columns of data to the right of Name that you wish to pick up. One way would be to insert a new column in this set of data (lets say it is on Sheet1) at column C, and enter the following =A1&" | "&B1 Copy down column C to the extent of your data. Assuming your data range before was A1:G100 then your new data range to look up would be C1:H100 Then on Sheet2, in cell C1 enter =VLOOKUP(A1&" | "&B1,Sheet2!$C$1:$H$100,2,0) Change ranges to suit. -- Regards Roger Govier "nick" wrote in message ... Yeah i am using my policy #'s as the unique field to populate the name in a different worksheet. How is filter gonna help me tho??? "davesexcel" wrote: Can you use the policy numbers for your criteria? Or Have you thought of using the filter? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519155 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |