v-look

[royhern]

With v-look up i get the number 0 in a cell that should be empty. How can i get the cell to be blank when no data should be there.

Please advice on solution.

Thanks, roy

[Aladin Akyurek]

On 2002-04-01 11:25, royhern wrote:
With v-look up i get the number 0 in a cell that should be empty. How can i get the cell to be blank when no data should be there.

Please advice on solution.

Thanks, roy

Care to post the VLOOKUP formula that you're using?

[Anne Troy]

Probably:

=if(isblank(vlookup(cell,range,column)),"",vlookup(cell,range,column)

[spg2112]

Try this, changing the ranges of course.

=IF((VLOOKUP($H2,$A$2:$D$4,B$1,FALSE))="","",(VLOOKUP($H2,$A$2:$D$4,B$1,FALSE)))

Steve