blank space

[by1612]

I am an excel novice, developing price lists to use for my invoices
p.o.s, inventories, etc. In my look-up formulas, how can I have unuse
spaces return a blank space instead of #N/A?

I realize this question is sub-basic, but my need to know ha
outweighed my embarrassment in asking. :confused

 

[Frank Kabel]

Hi
maybe something like
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(..))

 

[Peo Sjoblom]

One way

=IF(ISNA(MATCH(A1,$B$2:$B$50,0)),"",VLOOKUP(A1,$B$2:$C$50,2,0))

 

[by1612]

thanks alot for your help. both tips that I received worked great