Forum Discussion

LaVada1050's avatar
LaVada1050
Copper Contributor
Aug 19, 2020
Solved

vlook up formula

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

Resources