Home |
Search |
Today's Posts |
#1
|
|||
|
|||
intellectual vlookup
Hi all,
this is a ponder I had rather than a real problem. Suppose I had a Vlookup array with a repeated value. eg a1 is john smith but a2 is also John smith is it possible to get the vlookup to return Both values, ideally at the same time. I do not have a spreadsheet that requires this, I was just wondering. Thanks, Danny |
#2
|
|||
|
|||
vlookup will return only single value. it is better to use macro, if you have multiple value -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277185 |
#3
|
|||
|
|||
Hi
and how should they be returned? In different cells or combined in one cell? -- Regards Frank Kabel Frankfurt, Germany "Danny J" schrieb im Newsbeitrag ... Hi all, this is a ponder I had rather than a real problem. Suppose I had a Vlookup array with a repeated value. eg a1 is john smith but a2 is also John smith is it possible to get the vlookup to return Both values, ideally at the same time. I do not have a spreadsheet that requires this, I was just wondering. Thanks, Danny |
#4
|
|||
|
|||
Both would be good. An intellectual problem I have been pondering.
Danny "Frank Kabel" wrote in message ... Hi and how should they be returned? In different cells or combined in one cell? -- Regards Frank Kabel Frankfurt, Germany "Danny J" schrieb im Newsbeitrag ... Hi all, this is a ponder I had rather than a real problem. Suppose I had a Vlookup array with a repeated value. eg a1 is john smith but a2 is also John smith is it possible to get the vlookup to return Both values, ideally at the same time. I do not have a spreadsheet that requires this, I was just wondering. Thanks, Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Using Cell references in VLookUp | Excel Worksheet Functions | |||
vlookup. | Excel Worksheet Functions |