vlookup formula question

[ryan_law2000]

Hello everyone, here is the vlookup formula that i have and seems to work.

=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?

 

[ryan_law2000]

Sorry i ment to put this title as Ignore Blanks on Vlookup formula...
All i want this to do is skip over the cell if its blank

 

[Jonmo1]

What is type of data is normally expected from the Vlookup, number or text?

If it's text, you can simply use the t function
=T(VLOOKUP(....))

Otherwise, you have to test the vlookup for ""
=IF(VLOOKUP(....)="","",VLOOKUP(....))

 

[ryan_law2000]

So i tried something like this but its not working... Im still getting a "0"
=IF(VLOOKUP(Table1412[[#This Row],[Material Number]],'0617 lookup'!$C$2:$I$1205,4)="","",VLOOKUP(Table1412[[#This Row],[Material Number]],'0617 lookup'!$C$2:$I$1205,4))

 

[Jonmo1]

Maybe do =0 instead of =""
=IF(VLOOKUP(....)=0,"",VLOOKUP(....))

 

[ryan_law2000]

The only problem with that is its removing anything that has a "0" now...
I need to keep everything that originally had a "0" and remove only the blanks that had nothing...

 

[ryan_law2000]

So I have been seeing a problem here...

I went to the table and put all the "0" to "123456789"
then went back to the table and all the cells that should be blank are now "123456789" even though i know for a fact they are not in the table... maybe its just coping from a nother cell? I dunno...

So i changed all the "123456789" back to "0" and still all the cells (that are not in that table) are going to "0"

 

[Jonmo1]

I think you need to be using EXACT match in your vlookups
=IF(VLOOKUP(Table1412[[#This Row],[Material Number]],'0617 lookup'!$C$2:$I$1205,4,0)="","",VLOOKUP(Table1412[[#This Row],[Material Number]],'0617 lookup'!$C$2:$I$1205,4,0))

 

[ryan_law2000]

Thank you so much! Works perfect!

 

[Gauche]

hello, i have an excel doc made of two sheets 1st called client information and second called assignment.
how can i look for data to put in my 2nd sheets column if the 1st sheet is made of 10 different columns?
in my case, i want to look for data concerning seemingly only 2 columns but the problem is that they are not followed immediately.
the 1st sheet have 19 columns from A to T and i want only to take data in E and H. How can i do to put them in the formula? please reply