Vlookup Mutiple Values
Is it possible to use vloolup to find every instance of a lookup value
and return the column index value for every instance and put that into 1 cell separated by a coma or something like that? A B C D 1 ZZ Z M O 2 JJ J A X 3 RR D W E 4 GG G E G 5 RR J I V 6 E,V Example in cell A6 =VLOOKUP(B4,B:E,4,0) I want it to return the value of E,V Is this possible |
Vlookup Mutiple Values
Is it possible to use vloolup to find every instance of a lookup value
and return the column index value for every instance and put that into 1 cell separated by a coma or something like that? No Biff "Little Penny" wrote in message ... Is it possible to use vloolup to find every instance of a lookup value and return the column index value for every instance and put that into 1 cell separated by a coma or something like that? A B C D 1 ZZ Z M O 2 JJ J A X 3 RR D W E 4 GG G E G 5 RR J I V 6 E,V Example in cell A6 =VLOOKUP(B4,B:E,4,0) I want it to return the value of E,V Is this possible |
Vlookup Mutiple Values
Not with VLOOKUP, but you can try an IF/INDEX formula:
I assume that "ZZ" is located at B2. Then select B2:E6 and Insert Name Define Names in workbook: Array Next, define the name Out: Insert Name Define Names in workbook: Out Refers To: =IF(INDEX(Array,,1)=$B$6,INDEX(Array,,4)&",","") In cell A6, enter this formula: =INDEX(Out,1)&INDEX(Out,2)&INDEX(Out,3)&INDEX(Out, 4)&INDEX(Out,5) |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com