SOLVED

vlook up formula

Copper 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 (Copper Contributor)
Solution

@LaVada1050 

Change the formula to

 

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

Just what I needed!
Thank You
1 best response

Accepted Solutions
best response confirmed by LaVada1050 (Copper Contributor)
Solution

@LaVada1050 

Change the formula to

 

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

View solution in original post