Aug 18 2020 06:07 PM
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
Aug 18 2020 11:14 PM
SolutionAug 18 2020 11:14 PM
SolutionChange the formula to
=IFERROR(VLOOKUP(C4,K4:L302,2,FALSE),"")