vlookup for words content when there are duplicate values in the lookup-column

W

William Poh Ben

Hi,

Would appreciate if someone help me here.

Thanks in advance.

When I vlookup Material1 to Material2 for the Project No, I get
the vlookup Project No. as 222-56 for all the duplicate Material
values.
What formula to use so that when there are duplicate values in
Material2, I want to have vlookup looking to match Project No. containg
"AA" as 1st choice ? (if no Project No. containing "AA", then looks for
its content "AB" and subsequently looks for "AC" if there is no "AB").



ColumnA ColumnB ColumnC
Material2 Duplicate? Project No.
224410 duplicate 222-AC
224410 duplicate 222-AB
224410 duplicate 222-AA
326544 no 110007


Material1 Vlookup
224410 222-56
224410 222-56
224410 222-56
527770 #N/A
 
Top