SOLVED

vlook up formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1597696%22%20slang%3D%22en-US%22%3Evlook%20up%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597696%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EVlook%20up%20Formula%20Needed%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3Ei%20need%26nbsp%3B%20a%20formula%20where%20everyday%20I%20can%20put%20a%20new%20sheet%20and%20it%20will%20automatically%20add%20any%20matching%20notes%20from%20previous%20sheets.%20I%20want%20to%20find%20%26amp%3B%20match%20the%20information%20found%20in%20c2%20on%20sheet%201%20to%20c2%20sheet%202%20and%20input%20the%20notes%20in%20i2%20sheet%201%20onto%20sheet%202%20i2%2C%20if%20there%20are%20no%20notes%20leave%20blank%20%3DVLOOKUP(C4%2CK4%3AL302%2C2%2CFALSE)%20returned%20some%20info%20but%20other%20was%20NA%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1597696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1597983%22%20slang%3D%22en-US%22%3ERe%3A%20vlook%20up%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F763870%22%20target%3D%22_blank%22%3E%40LaVada1050%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%3E%3DIFERROR(VLOOKUP(C4%2CK4%3AL302%2C2%2CFALSE)%2C%22%22)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1600109%22%20slang%3D%22en-US%22%3ERe%3A%20vlook%20up%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600109%22%20slang%3D%22en-US%22%3EJust%20what%20I%20needed!%3CBR%20%2F%3EThank%20You%3C%2FLINGO-BODY%3E
New Contributor

Vlook up Formula Needed
 
i need  a formula where everyday I can put a new sheet and it will automatically add any matching notes from previous sheets. I want to find & match the information found in c2 on sheet 1 to c2 sheet 2 and input the notes in i2 sheet 1 onto sheet 2 i2, if there are no notes leave blank =VLOOKUP(C4,K4:L302,2,FALSE) returned some info but other was NA

2 Replies
best response confirmed by LaVada1050 (New Contributor)
Solution

@LaVada1050 

Change the formula to

 

=IFERROR(VLOOKUP(C4,K4:L302,2,FALSE),"")

Just what I needed!
Thank You