Am I understanding you correctly, the value you are looking up is there, but the column you want pulled in is blank?
1) You could use an IF formula =IF(VLOOKUP=0,"",VLOOKUP)
2) If the value you are looking up is not present use =IF(ISNA(VLOOKUP.....
I hope this helps.
This message was edited by Aaron on 2002-10-25 11:04