Non Blank Formula

[chetanmehra1989]

hello every one,


i have data in sheet1

A	B	C
Chetan1	2	1
Chetan2	0	5
Chetan3	5
Chetan4		5

<TBODY>
</TBODY>

Answer by this one as below in different sheet2 using by formula
when i use Simple vlookup its didn't work its showing bydefault 0 but i need formula who give me blank cell is equals to blank

A	B	C
Chetan1	2	1
Chetan2	0	5
Chetan3	5
Chetan4		5

<TBODY>
</TBODY>

 

[Joe4]

See this post here on the same topic: http://www.mrexcel.com/forum/excel-questions/620322-vlookup-returning-0-instead-blank.html

 

[chetanmehra1989]

i need simple solution ...

 

[Joe4]

There are various solutions offered there. Unfortunately, I don't think you are going find anything simpler. It is the nature of the beast you are working with!