ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   intellectual vlookup (https://www.excelbanter.com/excel-worksheet-functions/6152-intellectual-vlookup.html)

Danny J November 10th 04 10:02 PM

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



anilsolipuram November 10th 04 10:18 PM


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


Frank Kabel November 10th 04 10:22 PM

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




Danny J November 11th 04 08:49 AM

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 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com