Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Beyond VLOOKUP
I have a table array ,sorted by member’s last name, against which I use the VLOOKUP worksheet function to locate the name of an individual and return another piece of data in the array relevant to that individual.. Is there some way that I can check to see if the next name in the array is the same as the one indicated in my VLOOKUP function? -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=383976 |
#2
|
|||
|
|||
I am not sure what you are asking, but if it is how are you sure it is an
exact match, add a ,False as the last step in the Vlookup function. It will give you an error if there is not an exact match. "nebb" wrote: I have a table array ,sorted by members last name, against which I use the VLOOKUP worksheet function to locate the name of an individual and return another piece of data in the array relevant to that individual.. Is there some way that I can check to see if the next name in the array is the same as the one indicated in my VLOOKUP function? -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=383976 |
#3
|
|||
|
|||
Is the next name in the next row or the next column?
"nebb" wrote: I have a table array ,sorted by members last name, against which I use the VLOOKUP worksheet function to locate the name of an individual and return another piece of data in the array relevant to that individual.. Is there some way that I can check to see if the next name in the array is the same as the one indicated in my VLOOKUP function? -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=383976 |
#4
|
|||
|
|||
The next name is in the Next Row. -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=383976 |
#5
|
|||
|
|||
Have you tried experimenting with Pivot Tables? A Pivot Table would group the details by name. The key is to pick any one of the fields for the Data section and set it to "Count Of" Exampel: In the Pivot Table setup layout section: Row: Name, Product, Qty, Discount Data: Count of Product Would that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=383976 |
#6
|
|||
|
|||
Please *don't* multi-post.
See the answer to your first post in the excel group! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "nebb" wrote in message ... I have a table array ,sorted by member's last name, against which I use the VLOOKUP worksheet function to locate the name of an individual and return another piece of data in the array relevant to that individual.. Is there some way that I can check to see if the next name in the array is the same as the one indicated in my VLOOKUP function? -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=383976 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup with validation | 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 | |||
VLOOKUP not working | Excel Worksheet Functions |