Lookup/Match Formula, Enter "Name" Multiple Return Value Showing..???

[Jhon Mustofa]

hi all,

i am looking for some code/formula to figure it out problem lookup/match data with multiple return value

more detail please see my attack workbook

thanks and much appreciated!!

john m.

[MarvinP]

Hi Jhon,

See if this works for you. I got the first one using Index Match and then VLookup for the rest.

[azumi]

VLOOKUP and CHOOSE

[Jhon Mustofa]

works great, thank you MarvinP...

[Jhon Mustofa]

Azumi, thanks.. it's sweet answer.....

(matur nuwun, mas bro)..