ryan_law2000
Well-known Member
- Joined
- Oct 2, 2007
- Messages
- 738
Hello everyone, here is the vlookup formula that i have and seems to work.
right now if the cell in that table = "Blank" it automatically puts a 0 ... I want this to stay blank just like the table... How can i do that?
Code:
=VLOOKUP(Table1412[[#This Row],[Material Number]],'0617 lookup'!$C$2:$I$2549,4,)
right now if the cell in that table = "Blank" it automatically puts a 0 ... I want this to stay blank just like the table... How can i do that?