Vlookup with duplicate in Table array

[KIM Chanthan]

Hi,

Does anyone know how to do vlook up with duplicated value in table array?
Please find attached file for more detail on my questions.

Thanks for your time,
Chanthan

 

[Nebu]

Hi:

Pull a pivot.

Thanks

 

[KIM Chanthan]

Hi:

Pull a pivot.

Thanks

Beside pivot, is there any formula?
Thanks,

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[KIM Chanthan]

Hi:

Find the attached.

Thanks

Dear Nebu,
It works perfectly!!! Thanks you very much.