Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nick
 
Posts: n/a
Default HELP with VLOOKUP

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default HELP with VLOOKUP


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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nick
 
Posts: n/a
Default HELP with VLOOKUP

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default HELP with VLOOKUP

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using single cell reference as table array argument in Vlookup CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
Have Vlookup return a Value of 0 instead of #N/A Mr Mike Excel Worksheet Functions 4 May 25th 05 04:51 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"