Excel Formula Assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-1326767%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1326767%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%202%20sheets%2C%20one%20called%20parts%20and%20the%20other%20called%20colors%20-%20Parts%20has%204%20columns%20(A%3Dparts%2C%20B%3DCode%2C%20C%3DColor%2C%20D%3Dqty)%20The%20column%20names%20are%20on%20line%201%20and%20the%20table%20extends%20to%20line%2077.%20The%20second%20sheet%20called%20colors%20has%202%20fields(A%3DCode%2C%20B%3DColor).%20What%20I%20am%20trying%20to%20do%20is%20to%20populate%20the%20parts%20sheet%20to%20get%20the%20B%3DCode%20fields%20and%20look%20it%20up%20in%20the%20color%20sheet%20and%20take%20the%20actual%20color%20name%20and%20place%20it%20in%20the%20Color%20field%20in%20parts%20which%20is%20currently%20blank%20-%20Can%20anyone%20help%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1326767%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have a spreadsheet with 2 sheets, one called parts and the other called colors - Parts has 4 columns (A=parts, B=Code, C=Color, D=qty) The column names are on line 1 and the table extends to line 77. The second sheet called colors has 2 fields(A=Code, B=Color). What I am trying to do is to populate the parts sheet to get the B=Code fields and look it up in the color sheet and take the actual color name and place it in the Color field in parts which is currently blank - Can anyone help me

1 Reply
Highlighted

@Dgeehot 

You can try an index/match-see attached.