vlookup multiple values and return multiple values in one cell with comma seperated

Faysalalam2008 · Apr 6th 2013

[TABLE="width: 732"]

[tr]

[td]

code1

[/td]

[td]

code2

[/td]

[td][/td]

[td]

lookup Range1

[/td]

[td]

lookup Range2

[/td]

[td]

Return Value

[/td]

[td][/td]

[td]

Lookup

[/td]

[td]

Multiple Return

[/td]

[/tr]

[tr]

[td]

1001-01

[/td]

[td]

PET

[/td]

[td]

[/td]

[td]

1001-01

[/td]

[td]

PET

[/td]

[TD="align: right"]Red
[/TD]

[td][/td]

[td]

1001-01 & PET

[/td]

[TD="align: right"]Red,Green
[/TD]

[/tr]

[tr]

[td]

1001-01

[/td]

[td]

PET

[/td]

[td]

[/td]

[td]

1001-01

[/td]

[td]

PET

[/td]

[TD="align: right"]Green
[/TD]

[td][/td]

[td]

1001-01 & MPET

[/td]

[td]

Blue

[/td]

[/tr]

[tr]

[td]

1001-02

[/td]

[td]

PET

[/td]

[td][/td]

[td]

1001-02

[/td]

[td]

PET

[/td]

[td]

Blue

[/td]

[td][/td]

[/tr]

[tr]

[td]

1002-03

[/td]

[td]

MPET

[/td]

[td][/td]

[td]

1002-03

[/td]

[td]

MPET

[/td]

[TD="align: right"]Green
[/TD]

[td][/td]

[/tr]

[tr]

[td]

1001-01

[/td]

[td]

MPET

[/td]

[td]

[/td]

[td]

1001-01

[/td]

[td]

MPET

[/td]

[TD="align: right"]Blue
[/TD]

[td][/td]

[/tr]

[/TABLE]

I am trying to vlookup multiple value and return multiple values in one cell

Faysalalam2008 · Apr 6th 2013

Re: return multiple vlookup and return multiple values in one cell

find out what we can do?

**royUK** · Apr 6th 2013

Re: return multiple vlookup and return multiple values in one cell

You don't spend much time explaining your problem!!

You can only have one formula result per cell and lookups would alway return the same answer.

Faysalalam2008 · Apr 6th 2013

vlookup multiple values and return multiple values in one cell with comma seperated

Quote from royUK;658274

You don't spend much time explaining your problem!!

You can only have one formula result per cell and lookups would alway return the same answer.

But i am badly have to solve this problem.anyway thanks.

jarko28 · Apr 6th 2013

Re: vlookup multiple values and return multiple values in one cell with comma sepera

post a sample sheet, where does the 580 from 780,580 come from?

Armando Montes · Apr 6th 2013

Re: vlookup multiple values and return multiple values in one cell with comma sepera

Try:

Code

Function MyLookup(LookFor, FindCol As Range, GetCol As Range) As String
For Each c In FindCol
    If LookFor = c Then
        If MyLookup = "" Then
            MyLookup = Cells(c.Row, GetCol.Column)
        Else
            MyLookup = MyLookup & ", " & Cells(c.Row, GetCol.Column)
        End If
    End If
Next c
End Function

Display More

Faysalalam2008 · Apr 7th 2013

Re: vlookup multiple values and return multiple values in one cell with comma sepera

Please watch this time.

**royUK** · Apr 7th 2013

Re: vlookup multiple values and return multiple values in one cell with comma sepera

Watch what?

vlookup multiple values and return multiple values in one cell with comma seperated

Participate now!

Share