How to return multiple values using vlookup

[satputenandkumar0]

Hi Members,

I require array formula to return multiple values in c and d column.
Please find attached file for more clarification.

Regards,
Nandkumar S.

[:) Sixthsense :)]

Attachment is missing

[satputenandkumar0]

sorry sir i have edited origional post. Thanks for quick reply

[:) Sixthsense :)]

Can you please explain where you shown the expected result in the attached file?

[satputenandkumar0]

Sir,

I expected result in c and d column of 'MF' sheet

[:) Sixthsense :)]

Why don't you try using Pivot Table because it will automatically adapt the rows based on the number of matching rows for every Branch Code.

[satputenandkumar0]

Because I expected result in given format.

[:) Sixthsense :)]

Check the attached file whether it covers your expected result

[satputenandkumar0]

Dear sir,

I required result in given format which is same for all offices. How can I use index and vlookup function there???

[:) Sixthsense :)]

Show the expected result for 5 examples

[satputenandkumar0]

pls see attached file

[kvsrinivasamurthy]

Pl see attached file with Formula.

[satputenandkumar0]

Yes !!!

That's it I am looking for.........

rep added to

Thanks a lot

[kvsrinivasamurthy]

Tanks for the compliments.