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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com