vlookup problem please help

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Hi experts,

I have a problem in using vlookup function and have not been able to
resolve for a year+. Hope I can find some help in this great forum.
Many thanks in advance!

An example as below.
When I vlookup Material2 to Material1 for the Project No, I get
the result 222-56 for all the duplicate Material1 values.

In this case of having duplicate values in Material1 but associated
with different Project Numbers, how can I have vlookup function to
match the Project No. containg "AA" as 1st priority ? (and if there is
no Project No. containing "AA", then vlookup to look for Project No.
containing "AB". Then if there is no Project No. containing "AB",
subsequently vlookup for Project No. containing "AC" ).


Material1 Project No.
224410 222-AC
224410 222-AB
224410 222-AA
326544 110007


Material2 Matched Result
224410 222-56
224410 222-56
224410 222-56
527770 #N/A
 
Make sure on your range it has $ in front of the letters
and numbers. IE =Vlookup($A2,$B$2:$D$256,4,false) If
not... the number associated with B will increase with
your fill.
 
Back
Top